asp.net and Oracle

Question

Hi Friends please help me. I m Creating one Package (type Cursor) here i m create four different type of procedure i want to call this procedure into asp.net C# code behind . my Procedure is given bellow. package pandl_details as type t_pandl_cursor is ref cursor; procedure get_pl_details (P_CMP_CODE IN VARCHAR2P_LOC_CODE IN VARCHAR2P_ASOF IN dateP_PINDX IN VARCHAR2ddlDim1 IN VARCHAR2ddlDim2 IN VARCHAR2cur_pandl_details out t_pandl_cursor); procedure get_bl_details (P_CMP_CODE IN VARCHAR2P_LOC_CODE IN VARCHAR2P_ASOF IN dateP_PINDX IN VARCHAR2ddlDim1 IN VARCHAR2ddlDim2 IN VARCHAR2cur_pandl_details out t_pandl_cursor); procedure get_tl_details (P_CMP_CODE IN VARCHAR2P_LOC_CODE IN VARCHAR2P_ASOF IN dateP_PINDX IN VARCHAR2ddlDim1 IN VARCHAR2ddlDim2 IN VARCHAR2cur_pandl_details out t_pandl_cursor); procedure get_cs_details (P_CMP_CODE IN VARCHAR2P_LOC_CODE IN VARCHAR2P_ASOF IN dateP_PINDX IN VARCHAR2ddlDim1 IN VARCHAR2ddlDim2 IN VARCHAR2cur_pandl_details out t_pandl_cursor); end pandl_details Note :- This is my Procedure name which is given bellow get_pl_details get_bl_detailsget_tl_detailsget_cs_details this following is my Procedure name

FIROZ ANSARI · Answer

try this cmd.CommandText= PackageName.ProcedureName

Bikesh Srivastava · Answer

Hi Firoz You can access stored procedure very easily Visit here. http://www.c-sharpcorner.com/article/calling-oracle-stored-procedures-from-microsoft-net/

Manas Mohapatra · Answer

Try to call the SP through package name.SP name: OracleCommand objCmd = new OracleCommand(); objCmd.Connection = objConn; objCmd.CommandText =  pandl_details . get_pl_details  ; objCmd.CommandType = CommandType.StoredProcedure; objCmd.Parameters.Add( cur_employees  OracleType.Cursor).Direction = ParameterDirection.Output; try { objConn.Open(); OracleDataReader objReader = objCmd.ExecuteReader(); prvPrintReader(objReader); } catch (Exception ex) { System.Console.WriteLine( Exception: {0} ex.ToString()); } Follow below links that may help you: http://www.c-sharpcorner.com/article/calling-oracle-stored-procedures-from-microsoft-net/ http://stackoverflow.com/questions/18788509/code-for-calling-a-function-in-a-package-from-c-sharp-and-odp-net