Page 1 of 1
Oracle OCI vs ODBC error message
Posted: Wed Nov 05, 2003 3:51 am
by ewartpm
I have a customer who claims the ODBC stage will give the full error message, while the OCI stage truncates the error message to about 50 characters.
![Question :?:](./images/smilies/icon_question.gif)
How does one make the OCI give the full error message?
Thanks
Posted: Wed Nov 05, 2003 7:59 am
by chulett
AFAIK, you can't. Double-click on the message in the Director and you'll see all you are going to see from Oracle and DataStage. I don't recall an issue seeing the entire Oracle error, usually all you need is the type and number anyways. What I don't like is the fact that the "Value of the row" you had an issue with message gets truncated, so alot of times you get no help whatsoever (data-wise) with your problem.
Haven't had much use for ODBC yet, so haven't compared the two.