Home » Developer & Programmer » JDeveloper, Java & XML » How to use Collection or array (Oracle) in java (oracle 10g Java 5)
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.
Previous Topic: How can i took xml field data form clob clumn directly ?
Next Topic: Visual editor in JDeveloper
Goto Forum:
  


Current Time: Fri Mar 29 08:01:33 CDT 2024