-
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
Cheers!
OraKid.
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
|