Mystic1112
Programmer
Hello. If you can help me with a link to an explicit example or a snippet of code, I would appreciate it. I have an application that needs to call an Oracle stored procedure and pass several parameters for both input and output. One of the output parameters is a recordset type (pl/sql table) and I am having trouble getting a matching parameter definition because ADO doesn't appear to have an equivalent type for the parameter.
The procedure definition is as follows:
The code I use to call the procedure is as follows:
Again, any suggestions would be wonderful.
Thanks,
Mystic
The procedure definition is as follows:
Code:
PROCEDURE getCustomerInfo(call_id IN VARCHAR2, accountNum IN NUMBER, o_call_id OUT VARCHAR2, o_status OUT NUMBER, o_getAccountInfoTbl OUT GetAccountInfoTbl);
The code I use to call the procedure is as follows:
Code:
Set cmd.ActiveConnection = conn
cmd.CommandText = "{ call sp_stored_procedure(?, {resultset 100, o_call_id, o_status, o_getAccountInfoTbl})}"
cmd.CommandType = adCmdText
cmd.Parameters(0).Value = "10000"
cmd.Execute
Again, any suggestions would be wonderful.
Thanks,
Mystic