Siap pak yulius, terima kasih banyak, bertambah lagi ilmu saya, berarti nggak bisa pakai yang ORA_FFI, karena kami pakai yang web-client :D
Alwin.S 2010/6/19 yulius_wibowo <[email protected]> > > > Gunakan ORA_FFI kalau form-nya diakses menggunakan model client-server. > Karena ORA_FFI tidak bisa dipakai utk model web-client (pakai web browser). > > Sebaliknya gunakan Java Bean (PJC) kalau form-nya diakses menggunakan model > web-client (pakai web browser). Karena Java Bean (PJC) tidak bisa dipakai > utk model client-server. > > Hhhmmm, kalau utk contoh mungkin bisa digugel. > > bw > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Alwin > Sanjaya <alwinsanj...@...> wrote: > > > > Pak Yulius, contoh kasus nyata penggunaan ORA_FFI itu seperti apa pak? > dan > > apa kelebihan kalau kita menggunakan ORA_FFI ini? > > > > Regards, > > Alwin.S > > > > 2010/6/18 yulius_wibowo <yulius_wib...@...> > > > > > > > > > > > > Wah lebih rumit utk call shell script, spt rumitnya ngatur lalulintas > di > > > Jkt. > > > Kalau tertarik jg, silakan pakai ORA_FFI (Foreign Function Interface). > > > Tapi perlu dingat jg, kebamyakan pengguna masih demen pake Windoz. > > > > > > kalau saya sdh nggak ngimpi lagi koq. > > > > > > > > > bw > > > > > > --- In [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, > > > > "oracle@" <oracle@> wrote: > > > > > > > > kalo client nya linux/nix mungkin regex nya bisa dipakai... > > > > dari form bisa call shell kan? > > > > kalau winblowz, mungkin mesti install dulu regex for win? > > > > > > > > kalo paling mantebh buat sendiri fungsi regex :D > > > > > > > > maap bukan developer mania...piss ah > > > > > > > > monorail? subway? ngimpi ah... kreta express saja masih dumpel2an gak > > > > kebayang kalo di monorail dumpel2an dan ada yg naik diatas > > > gerbong....wuihhh > > > > seyemmmm > > > > > > > > > > > > 2010/6/18 <dev_orcl@> > > > > > > > > > > > > Kang Ujang, Mas Bowo... > > > > > > > > > > > > > > > > > > > > Bener yg penting "jadi" dan "sesuai deadline" :D > > > > > > > > > > dsaat itulah waktunya "dba kerja", mosok cuma ngecek space mulu > tiap > > > hari, > > > > > hhe... :b > > > > > > > > > > > > > > > > > > > > sesudah metromini ac, moga2 monorail + subway ya :D > > > > > > > > > > > > > > > > > > > > Nuhun > > > > > > > > > > Abip > > > > > > > > > > Powered by Telkomsel BlackBerry® > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > > > From: "yulius_wibowo" <yulius_wibowo@> > > > > > > > > > > Sender: > > > > > [email protected]<indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > > > > > > > > > Date: Fri, 18 Jun 2010 08:55:14 > > > > > > > > > > To: <[email protected] > > > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>> > > > > > > > > > > Reply-To: > > > > > [email protected]<indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > > > > > > > > > > Subject: [indo-oracle] Re: regexp_replace di form builder 6i > > > > > > > > > > > > > > > > > > > > Kang Ujang,... > > > > > > > > > > > > > > > > > > > > Memang betul, costly. > > > > > > > > > > Tapi pemikiran DBA dgn pemikiran programmer tuh memang terkadang > nggak > > > > > klop/beda. > > > > > > > > > > > > > > > > > > > > Kalau saya pribadi, utk kasus ini memposisikan diri sbg programmer. > > > > > > > > > > Yg penting apa yg diinginkan "jadi"...nggak mikir ke masalah > > > performance > > > > > (parsing, network bandwidth, dll). > > > > > > > > > > Toh aksesnya cuma ke fungsi & table "dual". > > > > > > > > > > Dan secara umum aplikasi yg menggunakan Oracle Form tidak ingin > > > "ngebut", > > > > > biar lambat asal selamat,...alon-alon asal kelakon. > > > > > > > > > > Sekali proses cukup satu atau beberapa records yg ditampilkan. > > > > > > > > > > > > > > > > > > > > Lain halnya utk aplikasi yg bersifat batch, memproses data dalam > jumlah > > > > > banyak...dituntut harus ngebut, spt metromini...kapan metromini di > > > AC'in ya? > > > > > :-) > > > > > > > > > > > > > > > > > > > > bw > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- In [email protected] > > > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com>, > > > > "oracle@" <oracle@> wrote: > > > > > > > > > > > > > > > > > > > > > > secara performance sepertinya bermasalah, > > > > > > > > > > > cuma mau parsing/replace saja butuh call ke db? > > > > > > > > > > > sungguh sangat costly sekali....hehehehe > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2010/6/18 Faridh Wisanggeni <faridh_wisanggeni@> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yups mas bowo > > > > > > > > > > > > Aku juga buatnya di function, jadi form tinggal return aja > hasilnya > > > > > > > > > > > > > > > > > > > > > > > > contoh yang saya gunakan adalah > > > > > > > > > > > > > > > > > > > > > > > > REGEXP_REPLACE(DATATEXT,'([^0-9A-Za-z])','') > > > > > > > > > > > > > > > > > > > > > > > > dan sukses, thanks yup mas bowo hihihihi > > > > > > > > > > > > > > > > > > > > > > > >________________________________ > > > > > > > > > > > > Dari: yulius_wibowo <yulius_wibowo@ <yulius_wibowo%40yahoo.com > >> > > > > > > > > > > > > Kepada: [email protected]<indo-oracle%40yahoogroups.com> > <indo-oracle%40yahoogroups.com><indo-oracle% > > > > 40yahoogroups.com> > > > > > > > > > > > > Terkirim: Jum, 18 Juni, 2010 07:55:01 > > > > > > > > > > > > Judul: [indo-oracle] Re: regexp_replace di form builder 6i > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yup, fungsi REGEXP_REPLACE secara "LANGSUNG" tidak bisa > > > > > dipakai/dipanggil > > > > > > > > > > > > lewat form 6i. > > > > > > > > > > > > > > > > > > > > > > > > Coba buat user function "di dalam" database yg > berisi/menggunakan > > > > > > > > > > > > REGEXP_REPLACE, kemudian panggil fungsi tsb dari Form6i. > > > > > > > > > > > > > > > > > > > > > > > > bw > > > > > > > > > > > > > > > > > > > > > > > > --- In > > > > > > > [email protected]<indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com><indo-oracle% > > > > 40yahoogroups.com>, > > > > > Alwin > > > > > > > > > > > > Sanjaya <alwinsanjaya@> wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > Dear Master, > > > > > > > > > > > > > Apakah pemanggilan regexp_replace bisa dilakukan di form > builder > > > 6i? > > > > > > > > > > > > Karena > > > > > > > > > > > > > setelah saya coba, ternyata form tidak mengenali function > > > > > regexp_replace > > > > > > > > > > > > > ini. Lalu bagaimana agar form dapat mengenalinya? Terima > kasih > > > > > bantuan > > > > > > > > > > > > dari > > > > > > > > > > > > > para master :) > > > > > > > > > > > > > > > > > > > > > > > > > > Regards, > > > > > > > > > > > > > Alwin.S > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > thanks and regards > > > > > > > > > > > ujang jaenudin > > > > > > > > > > > jakarta - indonesia > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > ------------------------------------ > > > > > > > > > > -- > > > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > > > Keluar: > > > > > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > <indo-oracle-unsubscribe%40yahoogroups.com> > > > > > > Website: http://indooracle.wordpress.com > > > > > http://www.facebook.com/group.php?gid=51973053515 > > > > > ----------------------------------------------- > > > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > thanks and regards > > > > ujang jaenudin > > > > jakarta - indonesia > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
