Actually, there are limits on number of DIANA nodes if this tells you
anything. Try decomposing your huge code into smaller chunks by
turning it into a package and decomposing into subroutines of the
package. One good thing in Oracle is that it offers you packages
in addition to single stored procedures and functions.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:1r5vgu8rp22k85srujbomhm7dl0jj6v25u_at_4ax.com...
> You must read
> 'Some versions of Oracle support only < 64k of *code*'
> which is quite different
>
> Regards
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
>
>
> On Tue, 18 Jun 2002 16:09:12 -0400, "Alan" <alanshein_at_erols.com>
> wrote:
>
> >How large is the text file? Some versions of Oracle only support <64K of
> >text.
> >
> >
> >
> ><Kenneth Koenraadt> wrote in message
> >news:3d0f2012.19330565_at_news.capgemini.se...
> >> On Tue, 18 Jun 2002 14:37:36 +0400, "Denis Melnikov" <dmelnik_at_col.ru>
> >> wrote:
> >>
> >> >Hi,
> >> >I'm trying to run some CREATE OR REPLACE PROCEDURE script. But both
> >> >SQLPlus Worksheet and SQLPlus fail with errors.
> >> >
> >> >Worksheet:
> >> >0/0 PLS-00123: program too large
> >> >
> >> >SQLPlus:
> >> >2273/0 PLS-00103: Encountered the symbol "end-of-file" when expecting
> >> > one of the following:
> >> > ; <an identifier> <a double-quoted delimited-identifier>
> >> > delete exists prior <a single-quoted SQL string>
> >> > The symbol ";" was substituted for "end-of-file" to continue.
> >> >
> >> >Do you have any proposal?
> >> >
> >> >I'm using 8.1.6.3.0 on Intel Solaris 7.
> >> >
> >> >
> >>
> >> As the error message friendly suggests, you are probably missing a ";"
> >> :
> >>
> >> create or replace procedure a is
> >> begin
> >> null;
> >> end <=========== HERE !
> >> /
> >>
> >
>
Received on Wed Jun 19 2002 - 03:28:30 CDT
