1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
Database db = DatabaseFactory.CreateDatabase(sDatabaseInstance);
DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper("phone_directory_pkg.sp_Emp_Directory_GetEmpInfo");
// Parameter in.
OracleParameter par_in = new OracleParameter("p_PersonIdNo", OracleType.Int32, 30000, ParameterDirection.Input, false, 0, 0, String.Empty, DataRowVersion.Default, Convert.ToInt32(this.txtPidNumber.Text.Trim()));
// Parameter out.
OracleParameter par_out = new OracleParameter("emp_ref_cursor", OracleType.Cursor, 30000, ParameterDirection.Output, true, 0, 0, String.Empty, DataRowVersion.Default, Convert.DBNull);
dbCommandWrapper.AddInParameter(par_in.ParameterName, par_in.DbType, par_in.Value);
dbCommandWrapper.AddOutParameter(par_out.ParameterName, par_out.DbType, par_out.Size);
DataSet ds = db.ExecuteDataSet(dbCommandWrapper); |
Partager