Re: DBMS_PIPE error

From: N Prabhakar <n_prabhakar_at_post1.com>
Date: 1997/07/31
Message-ID: <01bc9d8c$08f46d30$be6818d2@sin00119>#1/1

Hi there,

I had the same problem before, its because of one of the variables written to the dbms_pipe happened to be of NUMERIC data type. We changed our it to VARCHAR2 and it was OK.. May be its worth trying it... Please let me know the outcome,

Regards

N.Prabhakar

Meena <meena_at_gwcom.com> wrote in article <33CE75E2.57F3_at_gwcom.com>...
> Hi,
> We're running oracle 7.3.2.3 (PL/SQL 2.3.2.3.0) on Solaris 2.5.1.
> I've a trigger which'll get fired, when a record with a particular data
> is been inserted. My trigger is a PL/SQL procedure.
> The reader is the embedded PL/SQL ("C"). I am using the DBMS_PIPE
> package. I could able to compile both the reader and the writer
> successfully without any compilation errors.
> 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
>
>
> My role includes the "EXECUTE ANY PROCEDURE" system privillege.
>
> Any help on this is greatly appreciated.
>
> Thanks,
> Meena
>
Received on Thu Jul 31 1997 - 00:00:00 CDT