Home » SQL & PL/SQL » SQL & PL/SQL » I want to store a err message in Log/Txt file
I want to store a err message in Log/Txt file [message #23479] Wed, 11 December 2002 22:23 Go to next message
Arjun
Messages: 17
Registered: April 2001
Junior Member
Whwn ever the error will occur, that error i want to store in the txt or log file. How?

Report message to a moderator

Re: I want to store a err message in Log/Txt file [message #23482 is a reply to message #23479] Thu, 12 December 2002 07:41 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
definiatly possible within pl/sql, you can trap this errors (SQLERRM and SQLERRMSG ) and write it to a OS file (using UTIL_FILE).
with sql, there are not much. options.
use whenever < sqlerror / oserror >.
i have used this
whenever < sqlerror / oserror > exit.
But never triied
whenever < sqlerror / oserror > spool to_your_file.
and i dont know, how to open this file again in Append
mode(so, that next time the error occurs file is not overwrriten).

Report message to a moderator

Previous Topic: SOME DOUBT
Next Topic: How to remove blank space in oracle column???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 20:45:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.