public string ObtenerValor(int pcod_cliente_N)
{
List <OracleParameter> lst = new List <OracleParameter>();
string res = string.Empty;
try
{
// add parameters
OracleParameter param;
param = new OracleParameter("pcod_cliente_n", OracleDbType.Int32);
param.Value = 10;
lst.Add(param);
OracleClob data = (OracleClob)MyOracleUtils.execOracleSf2("pckTest.ObtValor3", lst, OracleDbType.Clob, this.conn);
res = (string)data.Value;
}
catch (Exception)
{
throw;
}
return(res);
}
public string ObtCallCSharp(string pSerViceName,
string pServiceRequest,
string pEntityName,
int pIndentityParamN,
string pDbOwner)
{
string res = string.Empty;
string invoker = string.Empty;
string packageName = string.Empty;
string methodName = string.Empty;
string[] scrap;
object objRes;
try
{
invoker = ObtServiceInvoker(pSerViceName);
if (invoker.Length > 0)
{
scrap = invoker.Split('.');
packageName = scrap[0];
methodName = scrap[1];
List <OracleParameter> lst = new List <OracleParameter>();
OracleParameter param = new OracleParameter("PPACKAGENAME", OracleDbType.Varchar2, 100);
param.Value = packageName;
lst.Add(param);
param = new OracleParameter("PSPPROCNAME", OracleDbType.Varchar2, 100);
param.Value = methodName;
lst.Add(param);
param = new OracleParameter("PSERVICEREQUESTID", OracleDbType.Varchar2, 100);
param.Value = string.Empty;
lst.Add(param);
param = new OracleParameter("PSERVICENAME", OracleDbType.Varchar2, 500);
param.Value = pSerViceName;
lst.Add(param);
param = new OracleParameter("PENTITYNAME", OracleDbType.Varchar2, 100);
param.Value = pEntityName;
lst.Add(param);
param = new OracleParameter("PINDENTITYPARAM_N", OracleDbType.Int32, 100);
param.Value = pIndentityParamN;
lst.Add(param);
param = new OracleParameter("POWNER", OracleDbType.Varchar2, 100);
param.Value = pDbOwner;
lst.Add(param);
objRes = MyOracleUtils.execOracleSf2("GE_PAMBCSHARPGEN.getCallService", lst, OracleDbType.Clob, this.conn);
res = ((OracleClob)objRes).Value;
}
}
catch (Exception)
{
throw;
}
return(res);
}
