Pro*C Error

From: Tom <twomack_at_bellsouth.net>
Date: 1998/02/13
Message-ID: <01bd3823$7ae3c440$79108ad1@president>#1/1

Hi:

I am trying to process an Oracle Pro*C file which contains the following:

  296      EXEC SQL EXECUTE
  297        BEGIN
  298         :v_Status := DBMS_PIPE.RECEIVE_MESSAGE('EXPORT_DRIVER');
  299       END;
  300      END-EXEC;
  301      if (v_Status == 0) {
  302        v_Code.len = 5;
  303        EXEC SQL EXECUTE
  304          BEGIN
  305            DBMS_PIPE.UNPACK_MESSAGE(:v_Code);
  306          END;
  307        END-EXEC;

PCC-S-0061: Error at line 298, column 31. PLS-201: identifier
'DBMS_PIPE.RECEIV

E_MESSAGE' must be declared

....!
PCC-S-0061: Error at line 298, column 9. PLS-0: Statement ignored

....!

PCC-S-0061: Error at line 305, column 21. PLS-201: identifier
'DBMS_PIPE.UNPACK

_MESSAGE' must be declared

......!

Oracle generates the two above errors. How should I declare these functions? Is there initaializations code for the DBMS_PIPE package I'm missing?

Please reply via e-mail -- and the newsgroup of course.

Thanks, Received on Fri Feb 13 1998 - 00:00:00 CST