Forum Discussion

vladm's avatar
vladm
Occasional Contributor
14 years ago

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.

1 Reply