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 VARCHAR2,P_LOC_CODE IN VARCHAR2,P_ASOF IN date,P_PINDX IN VARCHAR2,ddlDim1 IN VARCHAR2,ddlDim2 IN VARCHAR2,cur_pandl_details out t_pandl_cursor);

procedure get_bl_details (P_CMP_CODE IN VARCHAR2,P_LOC_CODE IN VARCHAR2,P_ASOF IN date,P_PINDX IN VARCHAR2,ddlDim1 IN VARCHAR2,ddlDim2 IN VARCHAR2,cur_pandl_details out t_pandl_cursor);

procedure get_tl_details (P_CMP_CODE IN VARCHAR2,P_LOC_CODE IN VARCHAR2,P_ASOF IN date,P_PINDX IN VARCHAR2,ddlDim1 IN VARCHAR2,ddlDim2 IN VARCHAR2,cur_pandl_details out t_pandl_cursor);

procedure get_cs_details (P_CMP_CODE IN VARCHAR2,P_LOC_CODE IN VARCHAR2,P_ASOF IN date,P_PINDX IN VARCHAR2,ddlDim1 IN VARCHAR2,ddlDim2 IN VARCHAR2,cur_pandl_details out t_pandl_cursor);

end pandl_details

 

 

Note :- This is my Procedure name which is given bellow

 

get_pl_details  ,get_bl_details,get_tl_details,get_cs_details this following is my Procedure name