Stored Proc

• Anupama

  Valued Member

  Points: 64

  More actions

  August 13, 2003 at 6:42 am

  #83041

  Hi,

  I want to execute a stored procedure by having an output parameter. Can any one tell me what is wrong in the below code

  sQuery = "exec usp_test a1 OUTPUT"

  gObjConn.Execute sQuery

  Response.write a1

  I want to get the output parameter from the SQL server and print it out in asp page.

  Thanks,

  Anu

• guarddata

  SSCertifiable

  Points: 6583

  More actions

  August 13, 2003 at 8:55 am

  #469761

  You will need to use an ADO Command object and set the parameters...or change the stored procedure to SELECT the output variable into a dataset.

  Guarddata-

• mattowen

  SSC Journeyman

  Points: 94

  More actions

  August 14, 2003 at 6:32 am

  #469912

  Guarddata is correct. Your code will look like this:

  set cmd = server.CreateObject("ADODB.Command")

  with cmd

  .ActiveConnection = gObjConn

  .CommandType = adCmdStoredProc

  .CommandText = "usp_test"

  .Parameters.Append .CreateParameter("a1", <type>, adParamOutput, )

  .Execute

  a1 = .Parameters("a1")

  .ActiveConnection = nothing

  end with

  set cmd = nothing

  Response.Write(a1)

  Of course, you would need to define the ADO constants by including ADOVBS.inc or copy and paste the appropriate values into the script.