Wrinting errors in a file

[Hakimca]

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

[bensr]

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

[sidshu]

If you are running thru a scheduler, you can point to generate
a log file and then rename with date time stamp.