4 Replies Latest reply: Apr 26, 2012 10:06 AM by 931576 RSS

    problem Compiling with SQLCHECK=SEMANTICS in C, throws  ORA-00942

    931576
      Hello,

      I am trying to execute a remote procedure in pro*c , after googling i found that the syntax i should use is this:

      EXEC SQL EXECUTE begin

      procedure_name()

      end;
      END-EXEC;

      and when i try to compile it i get the next message:

      PCC-S-02322, found undefined identifier
      Semantic error at line 514, column 12, file caecp.pc:
      EXEC SQL EXECUTE begin
      ...........1
      PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used

      And so if i add the flag i end up with lost of errors of the same type:


      Error at line 37, column 2 in file main.pc
      EXEC SQL select
      .1
      CSF-S-00000, ORA-00942: table or view does not exist


      I know the table exists and that i have access to them since i can do the queries directly on sqlplus.

      this are the flags am using to compile:


      /az/oracle11g/oracle/product/11.2.0/db_1/bin/proc iname=main INCLUDE=. INCLUDE=/az/sms/library/library/include INCLUDE=/az/oracle11g/oracle/product/11.2.0/db_1/precomp/public CPOOL=YES CTIMEOUT=300 LINES=YES MODE=ANSI COMMON_PARSER=YES CODE=ANSI_C SQLCHECK=SEMANTICS

      Pro*C/C++: Release 11.2.0.1.0 - Production on Wed Apr 25 10:49:32 2012

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

      System default option values taken from: /az/oracle11g/oracle/product/11.2.0/db_1/precomp/admin/pcscfg.cfg


      Any ideas???