PL/SQL procedures

Results 1 to 3 of 3

Thread: PL/SQL procedures

  1. #1
    Claudio Inglesi Guest

    Default PL/SQL procedures

    How can I run a PL/SQl procedure stored on a Oracle database from an ASP page?<BR>Thanks-

  2. #2
    Join Date
    Dec 1969

    Default example for stored package with in/out params

    This will call a package: <BR> &#039Recordset to hold results of update<BR> &#039--------------------------------------------<BR> loRs.CursorLocation = adUseClient<BR> <BR><BR> &#039open the connection<BR> loConn.CursorLocation = adUseClient<BR> loConn.Open connStringIn<BR><BR> &#039Call package that will delete from the plan and fm_plan tables.<BR> &#039-------------------------------------------------<BR> <BR> lsSql = "{call " & clientIdIn & ".h_plan_p.delete_plan(?,?,?)}"<BR> <BR> Set loCmd = New ADODB.Command<BR> With loCmd<BR> .ActiveConnection = loConn<BR> .CommandText = lsSql<BR> .CommandType = adCmdText<BR> <BR> Set param = .CreateParameter("plan_id_in", adVarChar, adParamInput, 4, planIdIn)<BR> .Parameters.Append param<BR> Set param = .CreateParameter("plan_cd_in", adVarChar, adParamInput, 25, planCdIn)<BR> .Parameters.Append param<BR> Set param = .CreateParameter("err_msg_out", adNumeric, adParamOutput)<BR> .Parameters.Append param<BR> End With<BR> <BR> <BR> loCmd.Execute

  3. #3
    Join Date
    Dec 1969

    Default RE: PL/SQL procedures

    Use a ADODB.Command object. Set the CommandType property = 4 (this means that you&#039re exceuting a stored procedure). Set the CommandText property equal to the name of the stored proedure and the ActiveConnection property equal to the connection to your database. Also, use the Command object&#039s Parameter collection to add parameters to your stroed procedure.

Posting Permissions

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