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
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)

select test (col1,col2)
bulk collect into p_test_collection
from test_tab;


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: Thu Oct 27 08:09:58 CDT 2016

Total time taken to generate the page: 0.11090 seconds