Hi folks,

I am working on oracle 9i on windows xp system.
while executing queries in SQL interpreter (oracle SQL* plus) i get
error messages
starting with ' ORA-XXXXX: ' .many times i can not understand the
errors because of limited description.

I got the detailed description on net @ http://www.cs.uvm.edu/oracle9doc/nav/error_search.htm
but i want to know -
Is there any help tool that get installed with oracle 9i in the
system
which wud give me detailed description about error on specifying the
error code(ORA-XXXX) without internet connection??

if yes, tell me path of that help tool.

regards.

On Jun 13, 7:28 am, sunshine <ravindra.har... (AT) gmail (DOT) com> wrote:
I would read this link and implement the oerr.java code provided:

http://www.oracleutilities.com/OSUtil/oerr.html


David Fitzjarrell

sunshine wrote:
If you are on Unix/Linux, Oracle includes the 'oerr' utility. I'm not
sure why they do not include this on Windows. Otherwise, you can use the
Oracle documentation:

http://download-east.oracle.com/docs...a96525/toc.htm


HTH,
Brian


--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

On Jun 13, 10:33 am, Brian Peasland <d... (AT) nospam (DOT) peasland.net> wrote:
It's not included on Windows because:

1) It's a shell script
2) It uses sed and awk to parse the message file, utilities not
installed on Windows

The java option I posted does a good job of emulating the oerr shell
script functionality.


David Fitzjarrell

The documentation is on the CD that contains the 9i server s/w.

You can download it from:
http://www.oracle.com/technology/doc.../oracle9i.html

You can use the following pl/sql from within sql*plus to get the error
details, by entering the error number when prompted:

set serveroutput on size 1000000
begin
dbms_output.put_line( sqlerrm(-&verr) );
end;
/



In article <1181737728.895393.250570 (AT) j4g2000prf (DOT) googlegroups.com>,
ravindra.harige (AT) gmail (DOT) com says...