private void Form1_Load(object sender, EventArgs e) { DbCOM.OraDB ora = new DbCOM.OraDB(); // DataTable dt = ora.SelectProcedure("PKG_RPT_HRM_CONTRACT.SELECT_RENEWAL_CONTRACT_WORKER"); DataTable dt = Master_Select(""); MessageBox.Show(dt.Rows.Count.ToString()); }
private DataTable Master_Select(string argType) { DbCOM.OraDB MyOraDB = new DbCOM.OraDB(); MyOraDB.ReDim_Parameter(4); MyOraDB.Process_Name = "PKG_RPT_HRM_CONTRACT.SELECT_RENEWAL_CONTRACT_WORKER"; MyOraDB.Parameter_Name[0] = "ARG_YMD_FRM"; MyOraDB.Parameter_Name[1] = "ARG_YMD_TO"; MyOraDB.Parameter_Name[2] = "ARG_DEPCODE"; MyOraDB.Parameter_Name[3] = "CV_1"; MyOraDB.Parameter_Type[0] = (int)DbCOM.OracleType.VarChar; MyOraDB.Parameter_Type[1] = (int)DbCOM.OracleType.VarChar; MyOraDB.Parameter_Type[2] = (int)DbCOM.OracleType.VarChar; MyOraDB.Parameter_Type[3] = (int)DbCOM.OracleType.Cursor; MyOraDB.Parameter_Values[0] = ""; MyOraDB.Parameter_Values[1] = ""; MyOraDB.Parameter_Values[2] = ""; MyOraDB.Parameter_Values[3] = ""; MyOraDB.Add_Select_Parameter(true); DataSet retDS = MyOraDB.Exe_Select_Procedure(); if (retDS == null) { return(null); } return(retDS.Tables[0]); //command.Parameters.Add("ARG_YMD_FRM", OracleDbType.Varchar2).Value = ""; //command.Parameters.Add("ARG_YMD_TO", OracleDbType.Varchar2).Value = ""; //command.Parameters.Add("ARG_DEPCODE", OracleDbType.Varchar2).Value = ""; //command.Parameters.Add("CV_1", OracleDbType.RefCursor).Direction = ParameterDirection.Output; }