| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: your mail
At 07:44 AM 2/15/96 -0800, you wrote:
>I can't say that there is a limit but I have a couple of 800+ line pl/sql
>scripts running. Each has more than 30 variables in the DECLARE section.
>
>On Thu, 15 Feb 1996, Peter Brenner wrote:
>
>> 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
>>
>
Hi
There is some limit in earlier version of PL/SQL which is was in order of 200-300 lines. This has been raised to somewhat higher value in ~1000 of lines. I am not sure which is the version number but it should around version 1.5.
Hope this helps.
Pratap
Hope this helps.
Email: singhp_at_bactc.com
Voice: 415-827-5868
Fax: 415-266-6324
 |
 |