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);
}
