Filling a Varray
Posted on 2003-12-03
I need help with the TYPE Varray....
I have a parser that will send me data ....I need to grab those names from the parser and use them as parameters into a stored procedure or the parser code can call the stored procedure and pass this in as parameters...I thought something like this...
Create type target_list_t is Varrary(100) OF Varchar2(20);
Create OR replace procedure Get_Targets ( list_in IN target_list_t)
FORALL listnum IN list_in..First list_in.LAST
Select * from tABle where thing = list_in ( listnum);
I have a PL/SQL book but I am unclear on HOW the arrary is filled....do I have to initialize EACH entry from 0-99?
Do I need an OUT statement? To output the select statement results?
Would it be better to just have a list of parameters in the create procedure and then check to see if they are null ..if not create a select statment? Again do I need an OUT for the results?
I dont have access right now to any data so Im writing kinda blindly without being able to test on a system....