Pro*C with Embedded PL/SQL: SQLCHECK=SEMANTICS
Oliver Kramer
I got the following error if i compile my .pc-program:
Semantic error at line 62, column 12, file ff.pc:
EXEC SQL EXECUTE
...........1
PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL
blocks are us
ed
I've tried to compile with two other lines additionally before and
after my PL/SQL-Block:
EXEC ORACLE OPTION (SQLCHECK=SEMANTICS) => before
EXEC ORACLE OPTION (SQLCHECK=SYNTAX) => after (to restore old
"environment")
Now, more error messages were flying on my screen ....
Anybody knowing why?
I compile my program with "make -f proc.mk ff". Other programs are ok.
But I i want to conpile with Emb. PL/SQL, it fails ....
Oliver
Ranga Chakravarthi
proc sqlcheck=semantics on the command line
"Oliver Kramer" <kramer...@t-online.de> wrote in message
news:8aa832bc.02052...@posting.google.com...
Ed prochak
What are the other error messages?
Did you also provide the precompiler with the proper database login
information? When using PL/SQL the precompiler must verify at compile
time if the packages procedures and functions you invoke truly exist.
(I'm assuming you are trying to invoke a precompiled PL/SQL procedure
via your "EXECUTE...", since you didn't show all of the embedded
block.)
Ed Prochak