a problem about oracle error ora-06508 [message #37238] |
Fri, 25 January 2002 16:49 |
acutero
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
Hi,
i have a store procedure to calculate some relative data. in this procedure,i used DBMS_SQL package to process dynamic sql,such as create view dynamically, and execute dynamical sql on this view. i compile and debug it successfully. So, i used my application to call it in a loop...while circle, this circle passed dynamic sql's parameters to the procedure and the procedure bind this parameters to dynamic sql's variable , if the circle times is less than 500 times , the procedure executed normally,but if the circle's counter is more than 500 times, i experienced such oracle errors, ora-04031: unable to allocate 4096 bytes of shared memory
ora-06508: can not found program unit being called
how can i do to solve this errors???
|
|
|
|