Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

pls-000123

Posted on 2001-09-12
6
635 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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

860 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