Pro*C/C++ Expert needed -- sqlca.sqlerrd[4]

Hi, Experts:

We need your help! Here is the problem. We wrote a library function to execute SQL statement. Usually, it works very well. But if there is a problem with the query statement (which can be very complicated), my life turns miserable. I have to spend a whole day or two to dig out those mis-typing or datatype mis-matching.

I know Oracle has something there to help. All I find out is that we are supposed to be able to use sqlca.sqlerrd[4] to identify the error location of SQL statement string (Let's take EXEC SQL PREPARE as example). But the reality is, sqlca.sqlerrd[4] always returns 0.

We did consult some other experienced proC/C++ programmer. Unfortunately, he experienced the exact same frustration as we are having now.

Anybody can have a hint? I really appreciate it.

Lu
817-264-6842 Received on Thu Nov 01 2001 - 09:42:43 CST