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

kramer.haine_at_t-online.de (Oliver Kramer) wrote in message news:<8aa832bc.0205240404.6452c8f9_at_posting.google.com>...
> 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

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 Received on Thu May 30 2002 - 18:20:11 CEST