Post reply

Throw an error/exception from a function

  • December 23, 2007 at 9:23 pm

    #184970

    Hi all,

    Is it possible for me to throw an exception/error from a function in sql server 2005? if yes, then please let me know the syntax for it.

    Thanks,

    Roopa.

  • December 23, 2007 at 10:30 pm

    #762480

    Roopa

    You cannot use the standard RAISERROR statement in a function nor can u use the TRY...CATCH construct to throw a error.

    How ever you can catch any error in the application that calls your function. In case you want to return a exeception for some validation purpose then you can set a pre-defined value to a variable and return that.

    Just curious.. do you really require a function or can u use a procedure for your needs.

    "Keep Trying"

  • December 23, 2007 at 10:50 pm

    #762485

    Hi,

    Functions are best suited for my requirement. I use the value returned by a scalar user defined function as a part of

    insert into t1 select *, function_f1() from t2.

    i cannot use a stored procedure here. however, there is a business validation that I want to do inside the function for which I will have to throw an exception / error.

    Please let me know if there is any method to do this or any work around for this...

    Thanks,

    Roopa.

  • December 23, 2007 at 11:30 pm

    #762491

    Just do a SELECT 1/0.... trust me, it'll throw an error 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply