Pro*C error message location ?

Some where along the line, Oracle decided to add  sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);

to the end of a EXEC SQL any_command_here ; in the Pro*C pre-processor.

One of the effects of this is that it nulls out

    sqlca.sqlerrm.sqlerrmc
which contains the failure reason when the command fails.

Does anyone know where else I can get an EXEC SQL failure message?

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.