Home » Developer & Programmer » JDeveloper, Java & XML » typing a java class that return array , and i control it in an oracle procedure ?????
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,
Previous Topic: Problem in loadjava on unix
Next Topic: Usage of COUNT in template of XML Publisher
Goto Forum:
  


Current Time: Fri Mar 29 01:02:28 CDT 2024