Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_PIPE error
In article <33CE75E2.57F3_at_gwcom.com>,
Meena <meena_at_gwcom.com> wrote:
>Subject: DBMS_PIPE error
>From: Meena
>Organization: GWCom Inc.
>Date: Thu, 17 Jul 1997 12:43:30 -0700
>Newsgroups: comp.databases.oracle.misc,comp.databases.server,comp.databases.tools
>
>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
Hi Meena,
I guess you're unpacking in other types or in an other order than you used to pack the data.
Cheers,
Ronald