General discussion


Oracle Errors

By petermetcher ·
Can anybody tell me if Oracle reports any additional information other than
RA-00904: invalid column name".

I am trying to get my application to recognise which word in the SQL text should be highlighted when this error occurs.

Thanks in anticipation.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Cause and Action will also be displayed if u use oerr utility

by dinesh_babu_r In reply to Oracle Errors


Normally the error message(sqlerrm) will contain those lines mentioned by you, if you want to know more about the cause & remedy you must use oerr utility (in solaris/unix boxes).
usage is like this

oerr ora 904
which will display some thing like this

00904, 00000, "invalid column name"
// *Cause:
// *Action:

Sometimes more specific information will be provided here.

Related Discussions

Related Forums