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
>
Received on Thu Oct 22 1998 - 00:00:00 CDT
