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

From: Ranga Chakravarthi <ranga_at_removethis.cfl.rr.com>
Date: Wed, 29 May 2002 23:38:02 GMT
Message-ID: <uDdJ8.11842$ec1.228830_at_twister.tampabay.rr.com>


try
proc sqlcheck=semantics on the command line

"Oliver Kramer" <kramer.haine_at_t-online.de> 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
>
Received on Thu May 30 2002 - 01:38:02 CEST

Original text of this message