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

Home -> Community -> Usenet -> c.d.o.misc -> Re: size limit for triggers

Re: size limit for triggers

From: Boris Oblak <boris.oblak_at_siol.net>
Date: 1998/10/22
Message-ID: <PpLX1.149$8e.4292766@news.siol.net>#1/1

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

Original text of this message

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