OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error [message #68]

Thu, 10 January 2002 07:59

sara
Messages: 36
Registered: February 2000

Member

hi,
where could i find the error codes & the relevent error definitions or say messages.

Report message to a moderator

Re: error [message #69 is a reply to message #68]

Thu, 10 January 2002 08:35

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

best place is error messages documentation.

if you want to know error message of particular error number, just run 3 lines script below (dont forget to run set serveroutput on )

SQL> set serveroutput on
begin
dbms_output.put_line(sqlerrm(to_number('-0'||'&errornumber')));
end;
/

or if you want to display first 100 error messages

SQL> set serveroutput on size 100000

begin
for i in 1..100 loop
dbms_output.put_line(sqlerrm(to_number('-0'||i)));
end loop;
end;
/

Report message to a moderator

Previous Topic:	create file problems with oracle
Next Topic:	utl_file and parsing a file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 13 14:10:27 CDT 2025