Niat nya sih biar bs digunakan lg dgn kondisi yg berbeda dan di sisi
aplikasi ketika ada perubahan tdk perlu redeploy.
Saya pernah coba bikin packet spt di bawah ini. Ketika di toad bs return
multi record walau pun tdk scr langsung, hasil query hrs di click lg br
return multi record. Tp di aplikasi gk bs melihat multi record tsb.
CREATE OR REPLACE PACKAGE pkg_multi_rec
AS
TYPE row_cursor is REF CURSOR;
FUNCTION fn_multi_rec(vndr in varchar2, t_name in varchar2) return
row_cursor;
END pkg_multi_rec;
/
CREATE OR REPLACE PACKAGE BODY pkg_multi_rec AS
FUNCTION fn_multi_rec(vndr in varchar2, t_name in varchar2)
return row_cursor
IS
c_return row_cursor;
BEGIN
OPEN c_return FOR
select type_name from TBL_REF_EQT_TYPES where VENDOR = vndr;
return c_return;
END;
end pkg_multi_rec;
--
Handy Sanjaya ST.
Operation Support System Engineer
PT Indonesia Comnets Plus (ICONPLN)
Indonesia Power Building 9th Floor
Jl Jendral Gatot Subroto Kav. 18
Jakarta 12950
email : [EMAIL PROTECTED]
web : www.iconpln.net.id
telp : 021 - 7532488 - ext : 156
[Non-text portions of this message have been removed]
