how to find oracle error in sqlprompt urgent

[kavithared]

example ora01740
thanks

[oravijay]

Hi,

Should refer to Oracle Error Manuals.

Thanks.
Vijay.

[kavithared]

NOTIME

[SANJAY_G]

Hi Kavitha,

Most of your posts are subjected "URGENT". I suggest you to take some time off and go through the manuals.

For a quick reference you can check the error details here
http://tahiti.oracle.com/pls/db901/db901.error_search

Sanjay

[pando]

dont expect fast response just you say urgent!

the time you spend writing here you can use it to find the error code! it only takes a couple of minutes to search for error code on tahiti.oracle.com

[nishant]

http://tahiti.oracle.com/pls/tahiti/...h?prefill=ORA-

[kavithared]

TO FIND OUT ERROR FROM SQL PROMPT ONLY I MEAN REASON FOR THAT ERROR

[aghosh]

Ok...... here is the piece from Oracle Error Manual


ORA-01740 missing double quote in identifier

Cause: An initial double quote (") was found without a closing quote. If an identifier contains a blank or special characters other than $, #, or _, it must be enclosed in double quotes.

Action: Add a closing double quote (") to the end of the identifier

[ales]

Reason?
Perhaps "show errors" helps you ... if you use SQL*Plus.

[kunche_rk]

If u r in Unix environment, Pl try the below at SQL prompt:
SQL> !oerr ora errornumber
ex: !oerr ora 03113