Asp working with Oracle Stored Procedures : OraOLEDB (0x80040E51)

From: Mr Not So Know It All (djscratchnsniffing_at_yahoo.com)
Date: 02/21/05 

Date: 20 Feb 2005 19:41:52 -0800

Im new to working with Oracle. Im trying to send my test DB an input
parameter and get an output parameter from a test procedure. I tested
the procedure successfully with a parameter.refresh. I was able to get
the parameter name and value for input and output parameters.
Unfortunately, when I try to send a value to the stored procedure I get
the following error:

OraOLEDB (0x80040E51)
Provider cannot derive parameter information and SetParameterInfo has
not been called.
/0022/OraclesSP.asp, line 23
<------------------------My Code------------------------------>
<%

        'dataconnection to database
        strConnect = "Provider=OraOLEDB.Oracle;User
ID=scott;Password=tiger;Data Source=EAPP;Persist Security Info=True"
        set objConn=Server.CreateObject("ADODB.connection")
        set objComm=Server.CreateObject("ADODB.Command")
        objConn.open strConnect
        set objComm.ActiveConnection=objConn

        'via Command object with stored procedure stored procedure
information
        'Command for Oracle (This works. I get the parameter names and
values
successfully)
        With objComm
                .CommandText = "GETDATA"
                .CommandType = 4 'adCmdStorecProc
                .Parameters.refresh
        End With
        response.Write("Parameters Count " & objComm.parameters.count &
"<br>")
        response.Write("P1 : " & objComm.parameters(0).Name & " " &
objComm.parameters(0).type & "<br>")
        response.Write("P2 : " & objComm.parameters(1).Name & " " &
objComm.parameters(1).type & "<br>")

        objComm.commandtype=1 'adCmdText
        objComm.commandtext="{ call GETDATA(?,?) }"
        objComm.Parameters(0).Value=7369 '< line 23 where error is >
        objComm.Execute
        response.Write("REturn & " & objComm.parameters(1) & "<br>")

        objConn.close
        set objConn = nothing
%>

Can someone please help me with ASP and Stored Procedures. Im using an
old WROX book - ADO 2.5 RDS Programming with ASP 3.0 as reference. The
author of the book demonstrates various ways to create parameters and
access to Oracle. I tried creating parameters and appending to a
command object, but that failed, too. Im open to whatever method works.
The author seems to like using the ODBC call syntax -> { call
GETDATA(?,?) }. He notes it works like manually appending parameters to
the Parameters collection.

Thanks in Advance.

Relevant Pages