• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 669
  • Last Modified:

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
0
kishj
Asked:
kishj
  • 3
  • 2
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
annu_vinayakCommented:
yes Kishi,

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

Annu
0
 
kishjAuthor Commented:
Thanks,
Jeff
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now