Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: "ORA-xxxxx" error's description?

Re: "ORA-xxxxx" error's description?

From: OneMan <om_at_nospam.org>
Date: Wed, 13 Jun 2007 19:02:15 +0100
Message-ID: <MPG.20da417f2bb7da3b989682@news.plus.net>


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

You can download it from:
http://www.oracle.com/technology/documentation/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.googlegroups.com>, ravindra.harige_at_gmail.com says...
> 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.
>
>
Received on Wed Jun 13 2007 - 13:02:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US