Returning Oracle Cursor/Array in ASP function

sparky753 · March 2nd, 2012, 01:20 AM

Does anyone know how to return an Oracle datatype which is a table of objects containing the following fields?

label VARCHAR2(50),
value VARCHAR2(100)

When I try the code below, I get an error: Provider error '80040e14' One or more errors occurred during processing of command.

Code:

Set returnVal = .CreateParameter("returnVal",adVarchar,adParamOutput)

Here is the code snippet:

Code:

Set cmdItem = Server.CreateObject("ADODB.Command")
	With cmdItem 
		.CommandText = "{myschema.mypkg.myproc (?,?,?,?,?,?)}"
		.CommandType = adCmdStoredProc
		.ActiveConnection = ORConn
		.Prepared = True
		Set param1 = .CreateParameter("",adNumeric,adParamInput)
		Set param2 = .CreateParameter("",adVarchar,adParamInput,255)
		Set param3 = .CreateParameter("",adNumeric,adParamInput)
		Set param4 = .CreateParameter("",adVarchar,adParamInput,255)
		Set param5 = .CreateParameter("",adVarchar,adParamInput,255)
		Set param6 = .CreateParameter("",adVarchar,adParamInput,255)
		Set returnVal = .CreateParameter("returnVal",adVarchar,adParamOutput)
			
		.Parameters.Append(param1)
		.Parameters.Append(param2)
		.Parameters.Append(param3)
		.Parameters.Append(param4)
		.Parameters.Append(param5)
		.Parameters.Append(param6)
	End With

	With cmdItem 

		.Parameters(0).Value = 1234567
		.Parameters(1).Value = "Credit"
		.Parameters(2).Value = 0
		.Parameters(3).Value = "4111111111111111"
		.Parameters(4).Value = "06"
		.Parameters(5).Value = "14"
		
		Set objRs  = .Execute
	End With