Re: size limit for triggers

I'm not sure, but I think the size limit of stored PL/SQL is about 64k.

Try to take some code from trigger to package or stored procedure/function.

Gerald Znidaric wrote:
>
> 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
>
> --------------------------------------------------------------------------------
>
> Gerald Znidaric <Gerald.Znidaric_at_mgm-edv.de>
> MGM EDV-Beratung GmbH
>
> Gerald Znidaric
> MGM EDV-Beratung GmbH <Gerald.Znidaric_at_mgm-edv.de>
> Frankfurter Ring 105a Work: +49 (89) 35 86 80-80
> Munich Fax: +49 (89) 35 86 80-88
> D-81477 Netscape Conference Address
> Germany Netscape Conference DLS Server
> Development of PowerBuilder and JAVA Applications, Specialized in Client/Server Development and Database Design
> Additional Information:
> Last Name Znidaric
> First Name Gerald
> Version 2.1
 

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
http://www.dd.ru