Hi All,

I want know how my plsql procedure with objects types & collection as out parameter can be handled in java.

My object declartion is as follows:

create or replace type ty_column is table of varchar2(250);

create or replace type ty_test as object
(
descr varchar2(40),
user_created number(12),
descr_long ty_column
);

create or replace type ty_test_table is table of ty_test;

My Procedure:

procedure get_ltr_type (p_column_name in r065908.lookup.column_name%type, p_column_value out ty_test_table)
is
v_arr ty_test_table;
v_clm ty_column:=ty_column();
begin
select column_value bulk collect into v_clm from r065908.lookup
where column_name=p_column_name;

select ty_test(column_name,user_created,v_clm)
bulk collect into p_column_value
from r065908.lookup
where column_name=p_column_name and column_value='TOPCORP';

end get_ltr_type;

Its really urgent.

Thanks in advance.

Kavitha