| typing a java class that return array , and i control it in an oracle procedure ????? [message #221223] |
Sun, 25 February 2007 14:03 |
m_arafa
Messages: 36
Registered: June 2006
|
Member |
|
|
hi all,
i want to type class that return array ,
and I control of it in oracle procedure row by row
with package "dbms_output.put_line" ...
please , how can i do that ??????
first,I type the following is sqlplus :-
SQL> create or replace java source name "demo"
as
public class demo {
public static int[] returnarray {
int[] nums = null;
for (int i = 0; i <= 5; i++) {
nums[i] = i;
}
return nums;
}
}
/
java created
and then,
i type the following but it fail ,I'can't .....
create or replace procedure retnums
as
loop
exit when .........;
java language 'demo.returnarray return nums'
end loop;
end;
/
help me,
thanks in advance,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
