Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Stored Procedures from ASP
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,
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Dec 06 1999 - 17:54:21 CST
![]() |
![]() |