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
Joined: May 10, 2001
Leslie Have you tried the getErrorCode and the getSQLState methods in the SQLException class? Also, make you are using getMessage too.
Joined: May 22, 2002
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.