Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010

    Unanswered: saving errors in a table / file.

    Hi Guys,

    I have procedure. say for example...

    select * from table_abc

    suppose, i get errors i.e table not found etc etc. I want to save the errors in a file or even in a table will do. Kindly educate me how to proceed.

    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Without knowing what language you're intending to use, it is hard to give you a concrete answer... Too much depends on the language and its capabilities and idioms.

    If the language that you're using to execute your SQL supports the TRY...CATCH construct, that would probably be the simplest answer. If the cost of function calls is cheap enough, that may also offer a viable solution.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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