Oracle-L: 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