I want to call the following procedure packaged from java ... anyone knows how to ... or, is that possible?
create package test as
type rec is record (
a char,
b number,
c varchar2(10));
type r is table of rec index by binary_integer;
procedure mnemonical (a out r);
end;
create package body test as
procedure mnemonical (a out r) as
cursos c is select a, b, c from t;
index integer;
begin
for i in c loop
a(index).a := i.a;
a(index).b := i.b;
a(index).c := i.c;
index := index + 1;
end loop;
end;
end;
F.
