Very Computer

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

Quote:> 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.

SQL> select empnumber from emp;

ORA-00904: invalid column name

Parse error at character offset 0 in SQL statement.

Oracle 8.1.6 on Linux and Tru64 and 8.1.7 on Solaris.

Regards...
                Michael