Hi,

I am getting this err msg PLS-00123: program too large..My procedure is 3000 lines long...which inserts records into a table(temp) and then manipulates and inserts into an another table...


The error msg says

: PL/SQL was designed primarily for robust transaction processing. One consequence of the special-purpose design is that the PL/SQL compiler imposes a limit on block size. The limit depends on the mix of statements in the PL/SQL block. Blocks that exceed the limit cause this error.



What is the block size...???

Regards,

sam