This discussion is archived
4 Replies Latest reply: Apr 26, 2012 8:06 AM by 931576 RSS

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

931576 Newbie
Currently Being Moderated
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???

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points