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 to identify the
error location of SQL statement string (Let's take EXEC SQL PREPARE
as example). But the reality is, sqlca.sqlerrd always returns 0.
We did consult some other experienced proC/C++ programmer.
Unfortunately, he experienced the exact same frustration as we are
Anybody can have a hint? I really appreciate it.