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

    Unanswered: saving errors in a table / file.

    Hi Guys,

    I have procedure. say for example...

    begin
    select * from table_abc
    end;

    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
    Location
    In front of the computer
    Posts
    15,579
    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.

    -PatP
    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
  •