Re: size limit for triggers
From: Boris Oblak <boris.oblak_at_siol.net>
Date: 1998/10/22
Message-ID: <PpLX1.149$8e.4292766_at_news.siol.net>#1/1
Date: 1998/10/22
Message-ID: <PpLX1.149$8e.4292766_at_news.siol.net>#1/1
[Quoted] [Quoted] 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>...Received on Thu Oct 22 1998 - 00:00:00 CEST
>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
>