Software

Ask something
Discussion Locked

Oracle Errors

0 helpful
1 reply

by petermetcher

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can anybody tell me if Oracle reports any additional information other than
:ORA-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.

Peter

1 reply

by dinesh_babu_r

Hi,

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.

This discussion is closed to new replies.