Re: DBMS_PIPE error

Nathan Hughes wrote:
>
> 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

You can also be sure you're comparing data columns to their respective types. If you compare a varchar2 column to a number literal; say 57, Oracle tries to convert each value in the varchar2 column to the literal data type to compare. If the varchar2 cannot be converted, you will also get this error. The error will only occur at runtime, since it is the conversion that is failing.

Something else to check.

-- 
"Came for the party, left on the run"

Robert Christenson
Gazette Technologies
robertoc#spam~be~gone#@fyiowa.infi.net