public void CargarDatos(int pcod_cliente_N) { List <OracleParameter> lst = new List <OracleParameter>(); string res = string.Empty; try { OracleParameter param = new OracleParameter("pcod_cliente_n", pcod_cliente_N); param.Value = 10; lst.Add(param); MyOracleUtils.execOracleSp2("pcktest.CargarDatos", lst, this.conn); } catch (Exception) { throw; } }
public DataSet GetSqlTblMetaData(string pOwner, string pTableName, string pVarRow, string pVarEntiName) { DataSet ds = null; string sql; try { List <OracleParameter> lst = new List <OracleParameter>(); OracleParameter param = new OracleParameter("POWNER", OracleDbType.Varchar2, 100); param.Value = pOwner; lst.Add(param); param = new OracleParameter("pTableName", OracleDbType.Varchar2, 100); param.Value = pTableName; lst.Add(param); param = new OracleParameter("pVarRow", OracleDbType.Varchar2, 100); param.Value = pVarRow; lst.Add(param); param = new OracleParameter("pVarEntityName", OracleDbType.Varchar2, 500); param.Value = pVarEntiName; lst.Add(param); param = new OracleParameter("pcur", OracleDbType.RefCursor, 100); param.Direction = ParameterDirection.Output; lst.Add(param); OracleCommand oraCmd = MyOracleUtils.execOracleSp2(" ME_pORAMETADATA.ObtieneOracleMeta", lst, this.conn); //((OracleRefCursor)p1.Value).GetDataReader() OracleDataReader dr = ((OracleRefCursor )(oraCmd.Parameters["pcur"].Value)).GetDataReader(); DataTable dt = new DataTable(); dt.Load(dr); ds = new DataSet(); ds.Tables.Add(dt); } catch (Exception) { throw; } return(ds); }