hi, di developer tinggal di-cast aja, jadi : select * from TABLE(bikin_angka(cast(:P_1 as numeric), cast(:P_2 as numeric)));
sebelumnya bikin dulu user parameter P_1 dan P_2 dengan tipe number/numeric. J Herman wrote: >Yulius Wibowo wrote: > > > >>Saya sudah coba pakai parameter ... sip tuh ... >>[menggunakan : select * from TABLE(gen_numbers(¶m1)) ] >> >> >> >> >> >bedanya parameter :param1 dan ¶m1 apa yah ? kenapa command diatas >kalau pake :param1 error ? >yang saya tahu : >¶m1 biasanya di replace dengan command sql (biasanya di pasang di >after parameter form trigger ). > >Kalau code dibawah saya modif dikit >1. create function > bikin_angka(n in number ,m in number ) > return array > PIPELINED > as > begin > for i in n .. m > loop > pipe row(i); > end loop; > return; > end; > >2. terus saya coba jalankan di sql plus : select from >TABLE(bikin_angkaz(3,5)); [running well ] > >kalau di report builder kalau mau pake parameter gimana caranya yah ? >saya coba >select * from TABLE(bikin_angka(¶m1,¶m2)) , katanya sintaks salah. > >Thanks. > >Herman > > Send instant messages to your online friends http://asia.messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
