} // 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
