i was searching for the example of subject mentioned and visited the following website
here is a tutorial to create such report, but i am confused as here in Report's Data Model they created 3 Ref Cursor Queries and did not Close the opened cursor, is there no need of this or any mistake or if it necessary, where have to Close the cursor?
First, they have created following Packages
PACKAGE concl_cv IS
type conclass_rec is RECORD
type conclass_refcur is REF CURSOR return conclass_rec;
PACKAGE cont_cv IS
type container_rec is RECORD
type container_refcur is REF CURSOR return container_rec;
PACKAGE port_cv IS
type portdesc_rec is RECORD
type portdesc_refcur is REF CURSOR return portdesc_rec;
then, created Functions which created in Ref Cursor Query in Data Model
function q_portdescRefCurDS return port_cv.portdesc_refcur is
open temp_portdesc for select department_id, department_name from departments;
function q_containerRefCurDS return cont_cv.container_refcur is
open temp_container for
function q_conclassRefCurDS return concl_cv.conclass_refcur is
open temp_concl for
nothing here any Close cursor statement. please help.
i am trying to explore this area of the development.
thanks in advance.