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