Oracle OCI vs ODBC error message

ewartpm · Post by **ewartpm** » Wed Nov 05, 2003 3:51 am

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.

How does one make the OCI give the full error message?

Thanks

chulett · Post by **chulett** » Wed Nov 05, 2003 7:59 am

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.