Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00123 Error
icon5.gif  PLS-00123 Error [message #262547] Mon, 27 August 2007 07:59 Go to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
hi all,

Please help me how to solve this error


when i compiled the package i got this error "PLS-00123 program too large"...
Re: PLS-00123 Error [message #262548 is a reply to message #262547] Mon, 27 August 2007 08:02 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What Oracle version?

MHE
Re: PLS-00123 Error [message #262549 is a reply to message #262547] Mon, 27 August 2007 08:06 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Prod
PL/SQL Release 10.1.0.3.0 - Production
CORE 10.1.0.3.0 Production

TNS for Linux: Version 10.1.0.3.0 - Production
NLSRTL Version 10.1.0.3.0 - Production
Re: PLS-00123 Error [message #262552 is a reply to message #262549] Mon, 27 August 2007 08:18 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Try compiling without DEBUG. You might be hitting a bug.

MHE
Re: PLS-00123 Error [message #262553 is a reply to message #262547] Mon, 27 August 2007 08:21 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
s. i am not using any debug procedures in our package. then why it comes?
Re: PLS-00123 Error [message #262554 is a reply to message #262553] Mon, 27 August 2007 08:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Your parameter PLSQL_DEBUG might be set to TRUE. Or you might be compiling via a tool like TOAD that defaults to compile with debug.

MHE
Re: PLS-00123 Error [message #262556 is a reply to message #262554] Mon, 27 August 2007 08:35 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
When I browsed MetaLink for this error, I came across several issues regarding PLS-00123. You might want to check there.

MHE
Previous Topic: problem in union
Next Topic: PL/SQL Tables
Goto Forum:
  


Current Time: Wed Dec 07 06:32:52 CST 2016

Total time taken to generate the page: 0.16836 seconds