Hi,
what's the right way to get an RefCursor with C#?
my Code:
OracleInProcServer.OraSessionClassClass OO4OSession = new OraSessionClassClass();
OracleInProcServer.OraDatabase OO4ODb = (OraDatabase)OO4OSession.get_OpenDatabase("a", "c"+ "/" + "c", 0);
OracleInProcServer.OraParameters OO4OParas = (OraParameters)OO4ODb.Parameters;
OO4OParas.Add("x", "", 2, 0, "x");
OracleInProcServer.OraParameter OO4OPara = (OraParameter)OO4OParas["x"];
OO4OPara.serverType = 102;
sSQL = "Begin abr.gibnum_ref_out(:x);end;";
OracleInProcServer.OraSqlStmt OO4OStm = (OraSqlStmt)OO4ODb.get_CreateSql(sSQL, 0);
OO4OStm.Refresh();
In this way I get the Code:
// OIP-04116: Cursor not ready for I-O
Thank's for help,
jörg