From: chiappa@my-deja.com Newsgroups: comp.databases.oracle.misc Subject: Re: Max size of an executed file on SQLPLUS Date: Fri, 02 Feb 2001 12:38:21 GMT Organization: Deja.com Lines: 15 Message-ID: <95e9ns$p5s$1@nnrp1.deja.com> References: <95cabc$mv2$1@reader1.imaginet.fr> NNTP-Posting-Host: 200.212.39.2 X-Article-Creation-Date: Fri Feb 02 12:38:21 2001 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) X-Http-Proxy: 1.0 SPPRX01, 1.0 x71.deja.com:80 (Squid/1.1.22) for client 200.212.39.2 X-MyDeja-Info: XMYDJUIDchiappa >160000 lines sounds like a great candidate for some tuning via > creating packages. Or at least break in some parts : inside PROG1 the poster asks for @@prog2, and @@prog3, and so on. Certainly it have some repetitive PL/SQL blocks , they must be a Function or Procedure inside the DECLARE area of prog1. []s Chiappa Sent via Deja.com http://www.deja.com/