SQLCHECK=SEMANTICS and USERID

From: James Droppa <droppa_james_e_nonlilly_at_lilly.com>
Date: 1996/03/07
Message-ID: <313F52C0.320_at_lilly.com>#1/1

I am attempting to create a C program using dbms_pipe commands but I am having trouble getting the program to compile. I've added the SQLCHECK=SEMANTICS option and the Pro*C manual stated that I must use the USERID option (even though the USERID portion of the same manual stated that the USERID option is not needed if auto-login is in place).

The error message I am getting (shown below) makes no sense to me and I hoping that it will make sense to someone. Below the error message is the portion of the code I am attempting to write.

Thanks in advance!

Jim

---

SYSTEM INFO:
Oracle7 Server Release 7.1.4.1.0 - Production Release With the distributed, parallel query and Parallel Server options PL/SQL Release 2.1.4.0.0 - Production

---

ERROR: Pro*C: Release 2.0.4.0.0 - Production on Thu Mar 7 13:01:51 1996

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

System default option values taken from: /opt/oracle/product/7.1.4/proc/pmscfg.h

Syntax error at line 46, column 21, file packrev.pc: EXEC ORACLE OPTION (USERID='/');

....................1

(1) PCC-S-02201, Encountered the symbol "USERID" when expecting one of the following:

   errors, hold_cursor, include, maxliteral, maxopencursors,    oraca, release_cursor, select_error, sqlcheck, etc.

---

PROGRAM Excerpt:

   EXEC ORACLE OPTION (SQLCHECK=SEMANTICS);    EXEC ORACLE OPTION (USERID='/');
   EXEC SQL EXECUTE

      BEGIN
          s := dbms_pipe.receive_message('Address_Test');
          if s <> 0 then
            raise_application_error(-20000, 'Error:' || to_char(s) ||
              'reading pipe');
          end if;
          dbms_pipe.unpack_message(testit);
      END;

   END-EXEC; Received on Thu Mar 07 1996 - 00:00:00 CET