I am running an .plb file at SQL*Plus that contains over 70 wrapped procedures. I get the following error for a particular procedure.
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 391296 bytes (PLS non-lib hp,PAR.C:parchk:ptb)
The error does not occur if only the single procedure is created.
Database info: version 8.1.6 on Windows NT
db_block_size = 8192
sort_area_size = 65536
sort_area_retained_size = 65536
db_block_buffers = 2048
shared_pool_size = 15728640
large_pool_size = 614400
java_pool_size = 20971520
Click Here to Expand Forum to Full Width