pls-000123

Greetings.

I am using 4.0.2.410 of PL/SQL Developer. I have a PL/SQL program that, when I compile it, gives me a PLS-000123 error. Now, I can compile this same program against a 7.3.4 db, and an 8i db, but not against a certain 8.0 db. (It happens with Toad also)

Any suggestions or parameters I can tweak?

Thanks
Jeff Kish
kishjAsked:
Who is Participating?
 
annu_vinayakConnect With a Mentor Commented:
yes Kishi,

You need to break that block into smaller block to execute it.

Annu
0
 
annu_vinayakCommented:
Can u provide the details that what r u trying to do.
0
 
annu_vinayakCommented:
The main reason for this error is that PL/SQL was designed primarily for robust transaction processing and the size of a PL/SQL block is limited and that depends on the PL/SQL compiler. The limit depends on the mix of statements in the PL/SQL block. Blocks that exceed the limit cause this error.

What you need to do is to modularize the program by defining subprograms, which can be stored in an Oracle database. Another solution is to break the program into two sub-blocks. Have the first block Iexecute first followed by the next.

Hope this helps.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
kishjAuthor Commented:
Right now, I am compiling a single package in a single file. Does this mean I need to break it up into separate packages that are compiled separately?
Thanks
Jeff
0
 
myerpzCommented:
Yes, the error means that your file is too large.
For a full list of PL/SQL errors, check out this link.

http://technet.oracle.com/doc/server.804/a58312/newch31.htm#2676

Sounds like you need to break up your package into smaller parts, perhaps based on the logical parts of your package.

It must be a big package, as I've never had this error.
Maybe you could define a set of functions to replace any processing your package does more than once ?

Anyway, good luck.

0
 
kishjAuthor Commented:
Thanks,
Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.