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.
Thanks in advance