OraFAQ Forum: Server Administration » PLS-00123 & Resource

Home » RDBMS Server » Server Administration » PLS-00123 & Resource_Limit parameter ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PLS-00123 & Resource_Limit parameter ? [message #58381]

Thu, 21 August 2003 08:39

David Edge
Messages: 2
Registered: August 2003

Junior Member

On an Oracle 9 database we have a PL/SQL package that does not compile because it gets an error PLS-00123 Program Too Large. The source code for this is wrapped and not our code.
It appears we only get the problem when the init parameter "resource_limit" is turned on. Since we need this init parameter on to get DB Profiles to work, is there any other way we get the package to compile i.e some other DB settings ?

Report message to a moderator

Re: PLS-00123 & Resource_Limit parameter ? [message #58382 is a reply to message #58381]

Thu, 21 August 2003 08:57

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i dont think it has anything to do with resource_limit.
it is becuase the parse tree growing too large!!.
PL/SQL uses a variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured intermediate language.
for more detailed information, big brother [url=http://asktom.oracle.com/pls/ask/f?p=4950:8:2623684977778070993::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:571023051648,]TomKyte[/url] as something to say.

Report message to a moderator

Re: PLS-00123 & Resource_Limit parameter ? [message #58383 is a reply to message #58382]

Thu, 21 August 2003 09:04

David Edge
Messages: 2
Registered: August 2003

Junior Member

Ok - I'll investigate. The strange thing is however that when we turn off resource_limit parameter and bounce the server, we can then compile the package ..

Report message to a moderator

Re: PLS-00123 & Resource_Limit parameter ? [message #63992 is a reply to message #58383]

Thu, 02 December 2004 19:22

nayan
Messages: 3
Registered: January 2001

Junior Member

The problem is that there is some limit for the size of datablock. So it was giving error when there were more rows.

DATABASE : error 6550 : {db_sqlexec : {ORA-06550: line 1, column 7807:
PLS-00123: program too large}}

So in order to keep the data block in it's limited size, we are splitting the block after appending every 1000 rows.

Now it does not give error when the size is more but transfers (inserts) the data in 3 to 4 blocks.
That is fine but performance is slow and there is more load on data base as instead of sending a block once, we are accessing it 3 or 4 times.

So we need to find out if in some way we can send large size of block. Is it any limitation of tcl (is ti possible in c code or anything else to send data block of larger size to oracle), or in any way we can specify from code to increase the data block size for that session or something like that.

Report message to a moderator

Previous Topic:	Job scheduling
Next Topic:	Discoverer inactive process / CPU use problems on Oracle 8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 22:31:24 CST 2025