How to fix PLS-123 
Author Message
 How to fix PLS-123

Datbase version:7.3.4.4 AIX 4.3.1
A user has just come by telling me that he is getting a PLS-123 error
after adding some lines to a procedure that is part of a package.
The Oracle documenation has the following to say about PLS-123

program too large:
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.  This limit depends on the mix of statements in
your PL/SQL
block.  Blocks that exceed the limit cause this error.

Action: The best solution is to modularize your program by defining
subprograms,
which can be stored in an Oracle database.  Another solution is to break
your
program into two sub-blocks.  Have the first block INSERT any data the
second
block needs into a temporary database table.  Then, have the second
block SELECT the data from the table.

Can anyone elaborate on this a little bit?  What do they mean by a
block?  A
begin...end sort of thing? Or something else..  Is it an upper limit to
the size of a
package?  What exactly is this limit anyhow?  It probably isn't num of
lines, so
what is it?

Thanks,
Dc.



Wed, 18 Jun 1902 08:00:00 GMT
 How to fix PLS-123

The limit is 64k.
Check user_objects for the current exact size.

Hth,

Sybrand Bakker, Oracle DBA


Quote:
> Datbase version:7.3.4.4 AIX 4.3.1
> A user has just come by telling me that he is getting a PLS-123 error
> after adding some lines to a procedure that is part of a package.
> The Oracle documenation has the following to say about PLS-123

> program too large:
> 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.  This limit depends on the mix of statements in
> your PL/SQL
> block.  Blocks that exceed the limit cause this error.

> Action: The best solution is to modularize your program by defining
> subprograms,
> which can be stored in an Oracle database.  Another solution is to break
> your
> program into two sub-blocks.  Have the first block INSERT any data the
> second
> block needs into a temporary database table.  Then, have the second
> block SELECT the data from the table.

> Can anyone elaborate on this a little bit?  What do they mean by a
> block?  A
> begin...end sort of thing? Or something else..  Is it an upper limit to
> the size of a
> package?  What exactly is this limit anyhow?  It probably isn't num of
> lines, so
> what is it?

> Thanks,
> Dc.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. i want the value of 123 if the value is 123.456..want only integer part from dec

2. error 100004 os error 123

3. Rounding numbers like 123 to 100, 255 to 200

4. Convert string (eg 123) to int

5. 123

6. MS SQL Server conflicting with NTP for port 123 - Windows 2000

7. Converting a Lotus 123 wks file to CSV

8. Job and Income Opportunity - 123 Easy Web Promotion Reseller Program

9. testing 123

10. Bulk insert and ,123 into real:error 4864

11. dump transaction returns error 3201, os kernal error 123 in script

12. Error 123 How do i solve this?


 
Powered by phpBB® Forum Software