| Author |
More detail from SQLException
|
Leslie Chaim
Ranch Hand
Joined: May 22, 2002
Posts: 336
|
|
Hi, I have this application and using dynamic SQL I often run in to the ORA-00904: invalid column name error. From my program how can I report more details such as the table and column name, or better yet is there any way I can get the message from the Oracle engine? Thanks for your help.
|
Normal is in the eye of the beholder
|
 |
Dave Vick
Ranch Hand
Joined: May 10, 2001
Posts: 3244
|
|
Leslie Have you tried the getErrorCode and the getSQLState methods in the SQLException class? Also, make you are using getMessage too.
|
Dave
|
 |
Leslie Chaim
Ranch Hand
Joined: May 22, 2002
Posts: 336
|
|
Dave, I tried it all and it does not give me what I am looking for. After I catch the SQLException I would like to somehow get the complete Oracle message the same as would be returned when using the OCI oerhms() function call.
|
 |
 |
|
|
subject: More detail from SQLException
|
|
|