Herman wrote:

>Yulius Wibowo wrote:
>
>  
>
>>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(&param1))
>>
>> 
>>
>>    
>>
Format query yang pertama jalan, query dengan parameter gak 
jalan.(ora-22905)
Yang saya coba manual adalah query dengan parameter.

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


Kirim email ke