Hi everybody,
How to append errors(exceptions) to a file as they occurs with PL/SQL. I want to manage to have a daily log of my errors.
Thanks in advance
Printable View
Hi everybody,
How to append errors(exceptions) to a file as they occurs with PL/SQL. I want to manage to have a daily log of my errors.
Thanks in advance
Hi,
Depending on what you want exactly and how the procedure is running you have got at least next possibilities:
1 UTL_FILE package delivered with Oracle
2 Create a log-table to insert all the logs.
Succes
If you are running thru a scheduler, you can point to generate
a log file and then rename with date time stamp.