Re: [indo-oracle] Re: Pipelined functions

[Herman]

Yulius Wibowo wrote:

>Saya sudah coba pakai parameter ... sip tuh ...
>[menggunakan : select * from TABLE(gen_numbers(&param1)) ]
>
>  
>
bedanya parameter :param1 dan &param1 apa yah ?  kenapa command diatas 
kalau pake :param1 error ?
yang saya tahu :
&param1 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(&param1,&param2)) , katanya sintaks salah.

Thanks.

Herman






------------------------ 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/