[indo-oracle] Re: Pipelined functions

[Yulius Wibowo]

TABLE(bikin_angkaz(3,5)); [running well ]
select * from TABLE(bikin_angka(&param1,&param2)) , -- error

Tanya:
Nama fungsinya : bikin_angka atau bikin_angkaz ???


Perbedaan :param dan &param
:param - bind variable, parameter hanya dipakai untuk menggantikan 
nilai saja.

&param - lexical variable, parameter bisa dipakai untuk menggantikan 
nilai dan juga syntax (bisa dipakai utk menggantikan nama table, 
where clause, order by clause ...)

CMIIW

Bowo




--- In indo-oracle@yahoogroups.com, Herman <[EMAIL PROTECTED]> wrote:
>
> 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/