ORACLE cursor - get output parameters
Hi.
I have some code which gives me opportunity to analyze output cursor.
//ADO connection initialization
var MY_DB = new ActiveXObject("ADODB.Connection");
var Cmd = new ActiveXObject("ADODB.Command");
var RecSet = new ActiveXObject("ADODB.Recordset");
//DB connection opening
MY_DB.ConnectionString = "Provider=MSDAORA;Data Source=dev;User Id=dev;Password=pass;OLEDB.NET=True;";
MY_DB.Open();
//DB command initialization
//or you can use "cmd = ADO.CreateCommand();"
Cmd.ActiveConnection = MY_DB;
Cmd.CommandType = adCmdText;
Cmd.CommandText = "{call pkg_rds_issue_stdata.p_get_rds_issue_stdata_fields(?, {resultset 0, op_cursor}, ?)}";
//Parameters initialization
Prm_Error = Cmd.CreateParameter("op_error_code", adInteger, adParamOutput); //param1
Prm_User = Cmd.CreateParameter("ip_user", adVarChar, adParamInput, 256);//param2
Cmd.Parameters.Append(Cmd.CreateParameter("op_error_code", adInteger, adParamOutput));
Cmd.Parameters.Append(Cmd.CreateParameter("ip_user", adVarChar, adParamInput, 256, "linda.quinn@db.com"));
//filling Hierarchy_items_db by array of hierarchy items from DB
RecSet = Cmd.Execute();
RecSet.MoveFirst();
while (!RecSet.EOF)
{
...
}
How i can get and analyze
op_error_code output parameter with cursor simultaneously?
Thanks in advance.