DBMS_PIPE error

From: Meena <meena_at_gwcom.com>
Date: 1997/07/17
Message-ID: <33CE791E.6417@gwcom.com>#1/1

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 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

My role includes the "EXECUTE ANY PROCEDURE" system privillege.

Any help on this is greatly appreciated.

Thanks,
Meena Received on Thu Jul 17 1997 - 00:00:00 CDT