Re: Max Size of a Trigger

Hi,

If you setup serveroutput size larger than your package size, your PL/SQL packages probably get through. In SQL*Plus:

sqlplus>set serveroutput on size 60000

Thanks,

Qing Miao
UCS, AT&T
qmiao_at_ucs.att.com

Mark Robbins wrote:
>
> Hi,
>
> I dont know about triggers but I am having similar
> problems with a package body.
> My current package body consists of about 4
> procedures/functions and is approximately 250-300
> lines and I am getting problems with wrong
> number/types of arguments to a function.
> But when I compile the function seperately (and
> change the calling code etc) it works fine.
>
> Is there a patch for this ?
>
> I guess one workaround would be to split the code
> into different sub packages but I am reluctant to
> do this.
>
> Thanks,
>
> Mark
Received on Thu May 08 1997 - 00:00:00 CDT