Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    193

    Unanswered: Where do untrapped errors go?

    Just curious as I had this in an interview. Actually it was for an Oracle Developer job but I presume it works the same way in SQL Server? Please bark if it doesn't. I was asked where an error goes if it doesn't meet any of the trigger criteria and yet is still an error someway or another. Isn't there a general safety net functionality, ie an ELSE condition for triggers? Obviously, I didn't know the answer. Please elaborate.

    ddave

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The error would go free, riding into the sunset, of course.

    Actually, Oracle has much more error handling abilities in PL/SQL than T-SQL, so the Oracle question is more difficult. T-SQL is catching up, as they have introduced the try-catch syntax in 2005. Still, not all errors can be caught, and those errors are sent to the calling program to be dealt with however the calling program sees fit.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I was gonna say untapped error heaven
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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