} // GetRowsUntypedRet
public DataTable GetRowsUntypedRet(Int64? pInInteger, Boolean convertColumnNameToTitleCaseInCaption = false, UInt32? optionalMaxNumberRowsToReadFromAnyCursor = null, OracleConnection optionalPreexistingOpenConnection = null) {
DataTable __ret = null;
OracleConnection __conn = optionalPreexistingOpenConnection ?? GetConnection();
try {
using (OracleCommand __cmd = new OracleCommand("ODPT.XMPL_PKG_EXAMPLE.GET_ROWS_UNTYPED_RET", __conn)) {
__cmd.CommandType = CommandType.StoredProcedure;
__cmd.BindByName = true;
__cmd.Parameters.Add(new OracleParameter("!RETURN", OracleDbType.RefCursor, null, ParameterDirection.ReturnValue));
__cmd.Parameters.Add(new OracleParameter("P_IN_INTEGER", OracleDbType.Int64, pInInteger, ParameterDirection.Input));
OracleCommandTrace __cmdTrace = IsTracing(__cmd) ? new OracleCommandTrace(__cmd) : null;
int __rowsAffected = __cmd.ExecuteNonQuery();
if (!((OracleRefCursor)__cmd.Parameters["!RETURN"].Value).IsNull)
using (OracleDataReader __rdr = ((OracleRefCursor)__cmd.Parameters["!RETURN"].Value).GetDataReader()) {
__ret = Hydrator.ReadResult(__rdr, convertColumnNameToTitleCaseInCaption, optionalMaxNumberRowsToReadFromAnyCursor);
} // using OracleDataReader
if (__cmdTrace != null) TraceCompletion(__cmdTrace, __ret.Rows.Count);
} // using OracleCommand
} finally {
if (optionalPreexistingOpenConnection == null) {
__conn.Close();
__conn.Dispose();
}
}
return __ret;
} // GetRowsUntypedRet
} // GetRowsTypedRet
public IList<TypeReturnUntyped> GetRowsUntypedRet<TypeReturnUntyped>(Int64? pInInteger,
bool mapColumnToObjectPropertyByPosition = false, bool allowUnmappedColumnsToBeExcluded = false, UInt32? optionalMaxNumberRowsToReadFromAnyCursor = null,
OracleConnection optionalPreexistingOpenConnection = null)
where TypeReturnUntyped : class, new() {
IList<TypeReturnUntyped> __ret = new List<TypeReturnUntyped>();
OracleConnection __conn = optionalPreexistingOpenConnection ?? GetConnection();
try {
using (OracleCommand __cmd = new OracleCommand("ODPT.XMPL_PKG_EXAMPLE.GET_ROWS_UNTYPED_RET", __conn)) {
__cmd.CommandType = CommandType.StoredProcedure;
__cmd.BindByName = true;
__cmd.Parameters.Add(new OracleParameter("!RETURN", OracleDbType.RefCursor, null, ParameterDirection.ReturnValue));
__cmd.Parameters.Add(new OracleParameter("P_IN_INTEGER", OracleDbType.Int64, pInInteger, ParameterDirection.Input));
OracleCommandTrace __cmdTrace = IsTracing(__cmd) ? new OracleCommandTrace(__cmd) : null;
int __rowsAffected = __cmd.ExecuteNonQuery();
if (!((OracleRefCursor)__cmd.Parameters["!RETURN"].Value).IsNull)
using (OracleDataReader __rdr = ((OracleRefCursor)__cmd.Parameters["!RETURN"].Value).GetDataReader()) {
__ret = Hydrator.ReadResult<TypeReturnUntyped>(__rdr, mapColumnToObjectPropertyByPosition, allowUnmappedColumnsToBeExcluded, optionalMaxNumberRowsToReadFromAnyCursor);
} // using OracleDataReader
if (__cmdTrace != null) TraceCompletion(__cmdTrace, __ret.Count);
} // using OracleCommand
} finally {
if (optionalPreexistingOpenConnection == null) {
__conn.Close();
__conn.Dispose();
}
}
return __ret;
} // GetRowsUntypedRet
} // ReadResultITTableBigPartial
public IList<TypeITTableBigPartial> GetRowsTypedRet<TypeITTableBigPartial>(Decimal? pInNumber, ref String pInOutVarchar2, ref IList<Int64?> pInOutAssocarrayInteger, out DateTime? pOutDate,
UInt32? optionalMaxNumberRowsToReadFromAnyCursor = null, OracleConnection optionalPreexistingOpenConnection = null)
where TypeITTableBigPartial : class, ITTableBigPartial, new() {
IList<TypeITTableBigPartial> __ret = new List<TypeITTableBigPartial>(); pOutDate = null;
OracleConnection __conn = optionalPreexistingOpenConnection ?? GetConnection();
try {
using (OracleCommand __cmd = new OracleCommand("ODPT.XMPL_PKG_EXAMPLE.GET_ROWS_TYPED_RET", __conn)) {
__cmd.CommandType = CommandType.StoredProcedure;
__cmd.BindByName = true;
__cmd.Parameters.Add(new OracleParameter("!RETURN", OracleDbType.RefCursor, null, ParameterDirection.ReturnValue));
__cmd.Parameters.Add(new OracleParameter("P_IN_NUMBER", OracleDbType.Decimal, pInNumber, ParameterDirection.Input));
__cmd.Parameters.Add(new OracleParameter("P_IN_OUT_VARCHAR2", OracleDbType.Varchar2, 32767, pInOutVarchar2, ParameterDirection.InputOutput));
__cmd.Parameters.Add(new OracleParameter("P_IN_OUT_ASSOCARRAY_INTEGER", OracleDbType.Int64, 50000, null, ParameterDirection.InputOutput));
__cmd.Parameters["P_IN_OUT_ASSOCARRAY_INTEGER"].Value = (pInOutAssocarrayInteger == null || pInOutAssocarrayInteger.Count == 0 ? new Int64?[]{} : pInOutAssocarrayInteger.ToArray());
__cmd.Parameters["P_IN_OUT_ASSOCARRAY_INTEGER"].CollectionType = OracleCollectionType.PLSQLAssociativeArray;
__cmd.Parameters.Add(new OracleParameter("P_OUT_DATE", OracleDbType.Date, null, ParameterDirection.Output));
OracleCommandTrace __cmdTrace = IsTracing(__cmd) ? new OracleCommandTrace(__cmd) : null;
int __rowsAffected = __cmd.ExecuteNonQuery();
if (!((OracleRefCursor)__cmd.Parameters["!RETURN"].Value).IsNull)
using (OracleDataReader __rdr = ((OracleRefCursor)__cmd.Parameters["!RETURN"].Value).GetDataReader()) {
__ret = ReadResultITTableBigPartial<TypeITTableBigPartial>(__rdr, optionalMaxNumberRowsToReadFromAnyCursor);
} // using OracleDataReader
pInOutVarchar2 = __cmd.Parameters["P_IN_OUT_VARCHAR2"].Status == OracleParameterStatus.NullFetched
? (String)null
: Convert.ToString(__cmd.Parameters["P_IN_OUT_VARCHAR2"].Value.ToString());
pInOutAssocarrayInteger = new List<Int64?>();
for (int _i = 0; _i < (__cmd.Parameters["P_IN_OUT_ASSOCARRAY_INTEGER"].Value as OracleDecimal[]).Length; _i++)
pInOutAssocarrayInteger.Add((__cmd.Parameters["P_IN_OUT_ASSOCARRAY_INTEGER"].Value as OracleDecimal[])[_i].IsNull
? (Int64?)null
: Convert.ToInt64(((__cmd.Parameters["P_IN_OUT_ASSOCARRAY_INTEGER"].Value as OracleDecimal[])[_i].ToString())));
pOutDate = __cmd.Parameters["P_OUT_DATE"].Status == OracleParameterStatus.NullFetched
? (DateTime?)null
: Convert.ToDateTime(__cmd.Parameters["P_OUT_DATE"].Value.ToString());
if (__cmdTrace != null) TraceCompletion(__cmdTrace, __ret.Count);
} // using OracleCommand
} finally {
if (optionalPreexistingOpenConnection == null) {
__conn.Close();
__conn.Dispose();
}
}
return __ret;
} // GetRowsTypedRet
