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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Max size of an executed file on SQLPLUS

Re: Max size of an executed file on SQLPLUS

From: <chiappa_at_my-deja.com>
Date: Fri, 02 Feb 2001 12:38:21 GMT
Message-ID: <95e9ns$p5s$1@nnrp1.deja.com>

>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/ Received on Fri Feb 02 2001 - 06:38:21 CST

Original text of this message

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