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.
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.