| How to use Collection or array (Oracle) in java [message #422444] |
Wed, 16 September 2009 08:50 |
abhijitsj
Messages: 6
Registered: September 2009
Location: Pune
|
Junior Member |
|
|
Hi All,
i have a type object
create table test_tab
(col1 varchar2(10),col2 varchar2(10));
create type test AS OBJECT
(
col1 varchar2(10)
,col2 varchar2(10));
create type test_collection as table of test;
procedure test(p_test_collection in out test_collection)
as
begin
select test (col1,col2)
bulk collect into p_test_collection
from test_tab;
end;
i want to call this procedure in java servlet.
i have an Action and form for it.
how do i supply data to procedure and get value from it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
