Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

maximum lines PL/SQL block

Status
Not open for further replies.

oerrora

IS-IT--Management
Nov 21, 2001
4
US
I was writing an pl/Sql anonymous block which dragged upto 4000+ lines. When I try to run the script, it says program is too long.

Is there any limit on number of lines in pl/sql block (Anonymous)?

Is there anyway I can increase it? I am using Oracle 8i.

Thanks for your help/advice in advance.

-Sat
 
The overall size of the block is the limit, not the number of rows. Unfortunately, I forget exactly what the limit is (I think it's 32K, but I can't say for sure) - somebody else will tell us, I'm sure.
But no, you can't increase the limit.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top