Wrinting errors in a file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Wrinting errors in a file

  1. #1
    Join Date
    Feb 2001
    Posts
    100
    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


  2. #2
    Join Date
    Feb 2001
    Posts
    180
    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
    Regards
    Ben de Boer

  3. #3
    Join Date
    Feb 2001
    Posts
    15
    If you are running thru a scheduler, you can point to generate
    a log file and then rename with date time stamp.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width