Hello there.. please help me pass an array of records from stored procedure to VB.
my proc declaration looks like this..
CREATE OR REPLACE PACKAGE SP_Load_Index AS
TYPE Return_arr_Typ IS RECORD(
FormUID Number,
RTName Index_RT.Name%TYPE,
FAName Index_FA.Name%Type,
RTTP Number,
FATP number,
Variation Form_Index.variation%TYPE,
Status From_Index.Status%TYPE);
TYPE Return_Set_Typ VARRAY(1000) Return_Arr_Typ;
TYPE Cur_Rec_Typ IS REF CURSOR RETURN Return_arr_type;
PROCEDURE Get_Indices(
CLUID IN number,
TUID IN number,
Cur_Rec IN OUT Return_Arr_Typ);
END SP_Load_Index;
-------- so i need to return this varray of records but i am not sure how to use ref cursor for creating the resultset.
please please please help.
thx
my proc declaration looks like this..
CREATE OR REPLACE PACKAGE SP_Load_Index AS
TYPE Return_arr_Typ IS RECORD(
FormUID Number,
RTName Index_RT.Name%TYPE,
FAName Index_FA.Name%Type,
RTTP Number,
FATP number,
Variation Form_Index.variation%TYPE,
Status From_Index.Status%TYPE);
TYPE Return_Set_Typ VARRAY(1000) Return_Arr_Typ;
TYPE Cur_Rec_Typ IS REF CURSOR RETURN Return_arr_type;
PROCEDURE Get_Indices(
CLUID IN number,
TUID IN number,
Cur_Rec IN OUT Return_Arr_Typ);
END SP_Load_Index;
-------- so i need to return this varray of records but i am not sure how to use ref cursor for creating the resultset.
please please please help.
thx