Oracle Database Discussions

Hi !

I didn't find a forum specific to pro*c, so here i am.

I've downloaded Oracle 11g and recompiled our applications using pro*c

We currently precompiling without any problem our sources against Oracle 7, 8, 9, 10.

With Oracle 11g, it doesn't work !

every EXEC SQL followed by a command works.
every EXEC SQL followed by a query generates the same error.

Example :

char *oracle_date_courante()
{
static char buf[SIZE_ORADATE+1];

EXEC SQL SELECT sysdate into :buf from DUAL;

if(ORA_SQLERROR())
{
oracle_error("sélection date courante");
buf[0]=0;
}

return buf;
}

PRO*C output :

Erreur Ó la ligne 105, colonne 2 dans le fichier src\oracle.pc
EXEC SQL
.1
PLS-S-00000, SQL Statement ignored
erreur sÚmantique Ó la ligne 105, colonne 2, fichier src\oracle.pc:
EXEC SQL
.1
PCC-S-02346, PL/SQL a trouvÚ des erreurs sÚmantiques

So, we investigated... And found that thoses errors come when we use the option sqlcheck=semantics.

If we use an inferiour check level, it works but because we use PL/SQL keywords, pro*c prints errors and wants us to provide the 'semantics' sqlcheck level !

So, it's a vicious circle !

Any ideas ?

Thanks...

Vincent