Pro*C with Embedded PL/SQL: SQLCHECK=SEMANTICS

Hi!

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 Received on Fri May 24 2002 - 14:04:54 CEST