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