Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to pass a varray of records from Stored Proc to VB

Status
Not open for further replies.

TOraptor

Programmer
Dec 13, 2001
8
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top