Stored Procedure OUTPUT Parameters

Discussion in 'Databases' started by Unique.Suren, Mar 3, 2010.

  1. #1
    Hi !

    how we can get value from OUTPUT parameters by calling a procedure.
     
    Unique.Suren, Mar 3, 2010 IP
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Hi,

    You're calling your proc. using sql variables, right?
    OK, so after the call, select @variable.
    Regards :)
     
    koko5, Mar 4, 2010 IP
  3. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #3
    the store proc must have variables declared as OUT

    ie. int varname out
     
    bartolay13, Mar 4, 2010 IP