Re: Pro*C mode problem

it_at_mikersoft.com (Rocky Dean Pulley) wrote in message news:<5ae526a4.0409080312.6892de30_at_posting.google.com>...
> I'm using Pro*C and I'm having a problem... Here is the simple code:
>
> now, when I run it with MODE=ORACLE, here is what I get:
>
> C:\work\db>proc getstuff.pc MODE=ORACLE
>
> Semantic error at line 10, column 22, file getstuff.pc:
> EXEC SQL CONNECT :url;
> .....................1
> PCC-S-02322, found undefined identifier
> Semantic error at line 11, column 30, file getstuff.pc:
> EXEC SQL SELECT VAL INTO :data FROM TMP;
> .............................1
> PCC-S-02322, found undefined identifier
>
>
> Am I wrong here? Shouldn't this work with MODE=ORACLE?
>
> If I put the "EXEC SQL BEGIN DECLARE SECTION;" around it then it
> works, but I need to be able to not use that...
>
> Thanks!

Why? You *must* declare ALL your bind variables in the declare section!

Sybrand Bakker
Senior Oracle DBA Received on Fri Sep 10 2004 - 08:39:55 CDT