|
|
| Re: how to use a ref cursor in report 6i [message #141310 is a reply to message #90177] |
Sat, 08 October 2005 08:10  |
me39che14
Messages: 3
Registered: May 2005
Location: Iran
|
Junior Member |
|
|
for example create this package :
PACKAGE concl_cv IS
type conclass_rec is RECORD
(ccap number,
classid number,
gwl number,
twl number,
htf number,
hti number,
notes varchar(50),
teu number);
type conclass_refcur is REF CURSOR return conclass_rec;
END;
and then you can use this :
function q_containerRefCurDS return cont_cv.container_refcur is
temp_container cont_cv.container_refcur;
begin
open temp_container for select cl.title, c.DOCKLOC,
c.PORTID, c.REPNO,
c.STATUS, c.key,
cl.key key2, c.classid classid2
from CONTAINERS c, conlabel cl
where cl.key=c.key
order by c.REPNO;
return temp_container;
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
