-
Does anybody experience the problem:
at "abc_proc"(procedure name), line 28
ORA-01000: maximum open cursors exceeded.
ORACLE 8i.
I have run this process successfully all the time before last week. But it occurs this error message every time when I run the same process right now. My maximum cursor open allowance is 350 in init.ora file. Basically, the process is two nested loop and some procedure calls as well as some update statements. Don't tell me rewrite the procedure or increase the max. cursor, because I can run the same procedure successfully before, and I didn't change anything later.
Appreciate for any help.
Thanks
-
Issue
ALTER SYSTEM FLUSH SHARED_POOL;
And then run the procedure.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|