Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: pl/SQL size

Re: pl/SQL size

From: TRL_India <0002089475_at_MCIMAIL.COM>
Date: Fri, 16 Feb 1996 01:34:00 EST
Message-Id: <9602160652.AA09054@alice.jcc.com>


Hi Peter,

The PL/SQL compiler imposes a limit on program size. The limit  depends on the mix of statements in your PL/SQL program and the  memory available on your platform. Programs that exceed the limit  cause a "program too large" compilation error.  The best solution to this problem is to modularize your program  by defining subprograms, which can be stored in an  ORACLE database.

Sanjay
208-9475_at_mcimail.com



Hi:

        Does anyone know if there is a limit to the number of lines and/or variables in a stand alone PL/SQL routine.

Thanks

Peter Brenner                                     Phone: (704) 329-5282
Coats American                                      Fax: (704) 329-5832
Charlotte, NC                                     Email: Peter.Brenner_at_coats.com

----------------------------------------------------------------------
Received on Fri Feb 16 1996 - 01:52:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US