Dear Handy sanjaya Kalo anda develop dengan front end Delphi bisa nggunakan komponen ODAC ato DOA
Anda bisa memanggil package apa saja termasuk standar DBMS package Anda tinggal panggil package nya di property Dan tentunya untuk menampilkan datanya melalu dbgrid Misalkan anda punya package pkg_multi_rec dan dalam specnya terdapat function fn_multi_rec Maka saat di panggil di property procedure yg tampil adalah pkg_multi_rec. fn_multi_rec Dan otomatis dalam komponen ini pun di dalamnya terdapat parameter2nya Sbg informasi komponen ODAC/DOA ini komponen native tanpa meerlukan BDE, jadi hanya memanpaatkan sqlnet /listenernya oracle yg aktif yg langsung akses ke OCI Dan optionnya bisa juga akses hanya melalui ip dan sid Regards, _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ferry Setiawan Sent: Tuesday, May 08, 2007 10:07 AM To: [email protected] Subject: Re: [indo-oracle] Function Multi Record saya biasanya pakai delphi untuk aplikasinya, dan sampai saat ini memang tidak bisa kalo menggunakan package, jadi harus berbentuk query. Regards Ferry Setiawan Pada tanggal 07/05/07, Handy <[EMAIL PROTECTED] <mailto:handy.sanjaya%40gmail.com> > menulis: > > 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] <mailto:handy%40iconpln.net.id> > web : www.iconpln.net.id > telp : 021 - 7532488 - ext : 156 > > [Non-text portions of this message have been removed] The information contained in this email is or may be confidential, legally privileged, and proprietary in nature or otherwise protected by law from disclosure and is intended solely for the use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying or use of any part of this mail is strictly prohibited and unlawful. If you received this email in error, please immediately notify the sender or our email administrator at [EMAIL PROTECTED] and delete it from your system. Thank you. [Non-text portions of this message have been removed]
