Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pro*C/C++ Expert needed -- sqlca.sqlerrd[4]

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

From: Xuehua Lu <xuehua.lu_at_sabre.com>
Date: Thu, 01 Nov 2001 09:42:43 -0600
Message-ID: <3BE16D73.7A44D69D@sabre.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US