TechFundu | ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,pl/sql vc2)

Home

Forum

TechFundu

Oracle

ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,pl/sql vc2)

(1 viewing) (1) Guest

Page: 1

TOPIC: ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,pl/sql vc2)

Forum Tools

#58

ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,pl/sql vc2) 2 Years, 5 Months ago	Karma: 0
Hi, I am getting below error when executing a storred procedure which fetches around 100K records. Any idea what can be the problem? ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,pl/sql vc2)

rpawar

Fresh Boarder

Posts: 12

Last Edit: 2009/12/09 10:33 By rpawar.

The administrator has disabled public write access.

#59

Re:ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,pl/sql vc2) 2 Years, 5 Months ago Karma: 0

Okay, It found out to be a coding problem...
Let's see why this problem...

Code:





CURSOR var_cursor IS

      SELECT allrows

      FROM table;



sbuf VARCHAR2(4000);



OPEN var_cursor;

FETCH var_cursor INTO sbuf;



WHILE (var_cursor%FOUND)

LOOP



 // Process data



// Now just before END LOOP if I don't add below fetch statement again then loops goes in infinite loop and after some time it gives ORA- 04030: out of process memory error.



FETCH var_cursor INTO sbuf;



END LOOP;