Re: size limit for triggers

Are you sure? I remember a limit (64k) in v7.2, but I had the impression that v7.3 allowed very, very large procedures...

If the database is 7.3 below, perhaps the limit is actually in the IDE that is being used - SQL*Navigator used to have a 64k limit, even though the database doesn't (later versions do not have this limitation). You can load larger procedures using sql*plus.

-jay

In article <PpLX1.149$8e.4292766_at_news.siol.net>,   "Boris Oblak" <boris.oblak_at_siol.net> wrote:
> There is a 64k limit for stored proceduras, packages, triggers.
>
> --
>
> Boris
> -------------------------------
> Boris Oblak
> ABAKUS Kranj, d.o.o.
> e-mail: boris.oblak_at_siol.net
>
> Gerald Znidaric wrote in message <362C53A5.2071D2D6_at_mgm-edv.de>...
> >Hi,
> >
> >is there a limit for the lines of code for triggers and/or stored
> >procedures within Oracle 7.3 (WinNT 4.0 + SP 3)?
> >
> >I have a trigger with some 2000 lines of code, which works perfectly
> >well. Then I add around 100 lines of code and try to compile it into the
> >database. The compiler reports an error at a position that looks quite
> >random. The problem can only be solved by removing some lines of code
> >(ANY lines of code, that is!). But putting part of the code under
> >comment is no solution, the compiler still reports an error then.
> >
> >This at least indicates that there is a limit in the size. But does
> >anyone know for sure?
> >
> >TIA,
> >Gary
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 00:00:00 CDT