Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Pro*C mode problem

Re: Pro*C mode problem

From: <sybrandb_at_yahoo.com>
Date: 10 Sep 2004 06:39:55 -0700
Message-ID: <a1d154f4.0409100539.18b1ee9c@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US