1 Reply Latest reply on Apr 20, 2005 6:34 PM by 82532

    How to call an oracle stored procedure from ASP

    55953
      I would really need your help in providing me inputs on how to call an oracle stored procedure using ASP. I have used the code below but it is not working. I am hitting a dead end already. Any inputs would be appreciated.

      Set cmdVerify = Server.CreateObject("ADODB.Command")

      cmdVerify.ActiveConnection = objConn

      cmdVerify.CommandText = "FSM_ADMIN.WEB_VERIFY.GET_VERIFY_INFO"

      cmdVerify.CommandType = adCmdStoredProc



      cmdVerify.Parameters.Append = cmdVerify.CreateParameter("@uexists", adVarChar, adParamOutput,250,"")

      cmdVerify.Execute

      ReturnError = cmdVerify.Parameters("@uexists")