Prinsipnya sama dengan menjalankan SQL di SQL*Plus:
1. create type array
as table of number
/
2. create function
gen_numbers(n in number default null)
return array
PIPELINED
as
begin
for i in 1 .. nvl(n,999999999)
loop
pipe row(i);
end loop;
return;
end;
/
3. First, test using SQL*PLus
select * from TABLE(gen_numbers(3));
COLUMN_VALUE
------------
1
2
3
4. Create Report using Report Builder (Wizard)
Source type : SQL Query
Data Source : select * from TABLE(gen_numbers(3))
dst...dst ...
Agar lebih dinamis, nilai "3" di sini, bisa diganti dengan parameter
select * from TABLE(gen_numbers(:param1))
OR
select * from TABLE(gen_numbers(¶m1))
CMIIW
Bowo
--- In [email protected], Herman <[EMAIL PROTECTED]> wrote:
>
>
>
> Ujang Jaenudin wrote:
>
> >rasanya pipelined function bisa di db 9i/10g, kalo developer
tools ...
> >kurang tau nih.... CMIIW
> >dan dulu pak bowo kayaknya pernah jelasin deh... coba aja di
search
> >arsip milist ini.
> >
> >
> >
>
> Yeap, justru saya tahu dari penjelasan pak bowo. :) saya udah
coba
> modif dan run di sql plus . cuman mindahin ke developer toolsnya
bingung.
>
> >saya sendiri belom pernah pake, tapi artikel ini kayaknya mudah
untuk
> >dicerna :
> >http://www.akadia.com/services/ora_pipe_functions.html
> >
> >
> >
> danke !
>
> >J
> >
> >
> >Herman wrote:
> >
> >
> >
> >>Hi,
> >>
> >>Ada yang tahu cara pemakaian pipelined functions di oracle
report
> >>developer ?
> >>Versi yang saya pakai adalah report developer 6i.
> >>
> >>Thanks
> >>
> >>
> >>
> >>
> >>
>
>
> --
> Herman
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
