-
Hi All,
I run a PL/SQL block which invokes a script file (which contains 15 thousands of SQL statements). Th
I got this error message
ERROR at line 118:
ORA-06550: line 672, column 224:
PLS-00123: program too large
I increased the Shared_pool_size to 80M but no way. There seems that it is a limitation of the PL/SQL compiler.
I need to execute this large script and I need to recuperate the error message if one statement fails and do a rollback. The script is well executed when directly invoked in SQL*PLUS. But If I launch it from the PL/SQL block I got the error. Is there a way to overcome this obstacle. Is there a way to handle errors in SQL*PLUS.
Please Help
Thanks in advance
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
|