Re: DBMS_PIPE error

Meena <meena_at_gwcom.com> writes:

> We're running Oracle 7.3.2.3 (PL/SQL 2.3.2.3.0) on Solaris 2.5.1.
> I've a trigger that gets fired, when a record with a particular data is
>been inserted. The trigger is the PL/SQL procedure and the reader is the
>embedded PL/SQL ("C") program. I'm using the DBMS_PIPE package. I could
>able to compile both successfully without any compilation error.
> But when I execute the reader, I get the following errors:
>
> ORA-06502: PL/SQL: numeric or value error
> ORA-06512: at "SYS.DBMS_PIPE

Make sure the column sizes in the table and all procedures/triggers are equal - this can happen when you try to populate say a varchar2(500) from a table that has column varchar2(700) - when the tuple gets that big, it'll fail. If the data isn't that long, proc will work fine.

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu