Pro*C mode problem

From: Rocky Dean Pulley <it_at_mikersoft.com>
Date: 8 Sep 2004 04:12:39 -0700
Message-ID: <5ae526a4.0409080312.6892de30_at_posting.google.com>

[Quoted] I'm using Pro*C and I'm having a problem... Here is the simple code:

#include <oci.h>
#include <stdio.h>
#include <sqlca.h>

void main()
{
 char *url = "web/dreamsys";
 char data[30];

   EXEC SQL CONNECT :url;
   EXEC SQL SELECT VAL INTO :data FROM TMP;    

   printf("val: %s\n", data);
}

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! Received on Wed Sep 08 2004 - 13:12:39 CEST