Home » SQL & PL/SQL » SQL & PL/SQL » error
error [message #68] Thu, 10 January 2002 07:59 Go to next message
sara
Messages: 36
Registered: February 2000
Member
hi,
where could i find the error codes & the relevent error definitions or say messages.
Re: error [message #69 is a reply to message #68] Thu, 10 January 2002 08:35 Go to previous message
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;
/
Previous Topic: create file problems with oracle
Next Topic: utl_file and parsing a file
Goto Forum:
  


Current Time: Fri Mar 29 00:52:22 CDT 2024