Oracle SQJ errors and SQLState

Folks,

I have a query regarding the SQLState string when catching exceptions thrown by SQLJ code. The SQLException can contain an error code, an SQLState, and an
error message, or a combination of all three.

I notice that the string held in the SQLstate is sometimes misleading, and that if an error code is present, one should pay attention to the code rather
than the SQLState string.
It seems that the SQLState does not get "cleared" automatically between SQL operations,
and thus can contain info from a previous call.

Is there a way to explicity clear the SQLState prior to an SQLJ operation ?

Thanks in advance...

Adam Lipscombe Received on Thu Jan 20 2000 - 05:55:08 CST