example ora01740
thanks
Printable View
example ora01740
thanks
Hi,
Should refer to Oracle Error Manuals.
Thanks.
Vijay.
NOTIME
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
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
TO FIND OUT ERROR FROM SQL PROMPT ONLY I MEAN REASON FOR THAT ERROR
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
Reason?
Perhaps "show errors" helps you ... if you use SQL*Plus.
If u r in Unix environment, Pl try the below at SQL prompt:
SQL> !oerr ora errornumber
ex: !oerr ora 03113