I am using ASP and ADO to connect to an Oracle DB. There is a stored procedure I want to call that returns a refcursor as one of the parameters. Everytime I try to execute I get a " [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement " message.
any solution? the database is setup correctly as others have used that same procedure w/ Perl and JDBC.
Here is a code snippet, the stored procedure 'command' in package 'package' has 2 parameters, the 1st is the refcursor, the 2nd is a text character
// Create the command object and set the query to be executed
Set objCmd = Server.CreateObject("ADODB.Command")
Set objCmd.ActiveConnection = objConn
objCmd.CommandType = adCmdStoredProc
objCmd.Parameters.Append(objCmd.CreateParameter("param2", adVarChar, adParamOutput, 4))
objCmd.CommandText = "package.command" //
refcur,:stat)
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.CursorType = adOpenStatic
objRS.LockType = adLockReadOnly
Set objRS = objCmd.Execute()
Thanks!
any solution? the database is setup correctly as others have used that same procedure w/ Perl and JDBC.
Here is a code snippet, the stored procedure 'command' in package 'package' has 2 parameters, the 1st is the refcursor, the 2nd is a text character
// Create the command object and set the query to be executed
Set objCmd = Server.CreateObject("ADODB.Command")
Set objCmd.ActiveConnection = objConn
objCmd.CommandType = adCmdStoredProc
objCmd.Parameters.Append(objCmd.CreateParameter("param2", adVarChar, adParamOutput, 4))
objCmd.CommandText = "package.command" //
refcur,:stat)Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.CursorType = adOpenStatic
objRS.LockType = adLockReadOnly
Set objRS = objCmd.Execute()
Thanks!
Facebook
Twitter