Solved

pls-000123

Posted on 2001-09-12
6
627 Views
Last Modified: 2007-11-27
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
Comment
Question by:kishj
  • 3
  • 2
6 Comments
 
LVL 1

Expert Comment

by:annu_vinayak
ID: 6478361
Can u provide the details that what r u trying to do.
0
 
LVL 1

Expert Comment

by:annu_vinayak
ID: 6478370
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
 

Author Comment

by:kishj
ID: 6479348
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 3

Expert Comment

by:myerpz
ID: 6480525
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
 
LVL 1

Accepted Solution

by:
annu_vinayak earned 50 total points
ID: 6481446
yes Kishi,

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

Annu
0
 

Author Comment

by:kishj
ID: 6482349
Thanks,
Jeff
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now