Stored Procedures from ASP

From: <bpaul1_at_my-deja.com>
Date: Mon, 06 Dec 1999 23:54:21 GMT
Message-ID: <82hibb$6mv$1@nnrp1.deja.com>

Hi, I am using ADO to call procedures stored in Oracle 8.0.4 from ASP.

My problem is getting values fom output paramaters when the procedure is part of a package. For exmple the following procedure:

create or replace procedure iWRecord (pID IN OUT NUMBER) as
begin

        pID := 200;
end;

Works fine when it is not part of a package. When I create a package (called "barrys") and add it to it the pID paramater is not updated when it is called.

Can anyone verify this problem and/or suggest a solution?

My ASP script follows:

' Open connection
Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "driver={Microsoft ODBC for Oracle}; server=ORC0; uid=xxxxx; pwd=yyyyy"

Set cmdStoredProc = Server.CreateObject("ADODB.Command") cmdStoredProc.ActiveConnection = oConn

cmdStoredProc.CommandType = 1
cmdStoredProc.CommandText = "{call barrys.iWRecord (?)}"

cmdStoredProc.Parameters(0).Value = CInt (1) cmdStoredProc.Execute

response.write "<H1>"
Response.write cmdStoredProc.Parameters(0).Value
Response.write "</H1>"

Thanks,

---

Barry

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 17:54:21 CST