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