Home » Infrastructure » Unix » Oracle Errors in Unix
Oracle Errors in Unix [message #97747] Mon, 16 December 2002 10:07 Go to next message
Reddy Peram
Messages: 52
Registered: December 2002
Member
Hi,
While running SQL (Oracle), if we get any error, it gives error code. Where to find explanation for that sql error code in UNIX, NT and SQL plus envoronments?
Thanks a lot!
Re: Oracle Errors in Unix [message #97759 is a reply to message #97747] Wed, 08 January 2003 09:19 Go to previous messageGo to next message
EAP
Messages: 2
Registered: January 2003
Junior Member
Execute "oerr error_type error_number" on Unix prompt.

For example :
ERROR at line 1:
ORA-20008: STRING LARGER THAN BUFFER INCREASE BUFFER SIZE OF FOPEN
ORA-06512: at "TH_ST6.TH_AU_UPD_RESP_PKG", line 154
ORA-06512: at line 1

So it will be, "oerr ora 6512"
Re: Oracle Errors in Unix [message #97776 is a reply to message #97759] Mon, 20 January 2003 07:41 Go to previous message
Rehan
Messages: 6
Registered: May 2002
Junior Member
in listener.ora add the string (QUEUESIZE=200) after PORT=1521)
Previous Topic: urgent !! how to reture value to unix from plsql block
Next Topic: ms_excel spread sheet to oracle table
Goto Forum:
  


Current Time: Fri Mar 29 03:51:59 CDT 2024