SQL & PL/SQL

hi...i am facing a complex problem. like, i have stored procedure with IN parameters and OUT parameters


these are the table types i declared in package specification....

TYPE t_v_id IS TABLE OF varchar2(400);
TYPE t_stat IS TABLE OF varchar2(400) ;
TYPE t_alt_sev IS TABLE OF VARCHAR2(100);
TYPE t_def_dt IS TABLE OF date;

v_id t_v_id;
stat t_stat;
alt_sev t_alt_sev;
def_dt t_def_dt;

in stored procedure, i executed one dynamic query using EXECUTE IMMEDIATE like...

l_data_where:= 'select vet_id,stat_desc,alt_sev_desc,def_dt from ...........';

EXECUTE IMMEDIATE l__data_where BULK COLLECT INTO v_id,stat,alt_sev,def_dt;

now ...i am inserted all the values into table types v_id,stat,alt_sev,def_dt.


here is the problem....?

how can i return these table type's as OUT parameters . i don't want to print it. i want to return it as values. i want to see all the rows with all the colums like....i am exactly expecting


procedure call:

my_package.my_procedure(var1,var2,var3...);

result;
v_id stat alt_sev def_dt
------ ------ --------- ---------



i hope you got my problem.....please show me a solution.

thanks in advance ....my friends.

Edited by: user9041629 on Jul 28, 2010 2:09 PM