Ok thank you deny i'll try it. cheers Gta
----- Original Message ---- From: Denny Kusumah <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, February 5, 2008 10:06:54 AM Subject: Re: [indo-oracle] About Form Oracle salam kenal gita, saya punya contoh untuk mengexpor data oracle ke excell. coding nya sbb : DECLARE pl_id ParamList; begin pl_id := Get_Parameter_ List('tempdata' ); IF NOT Id_Null(pl_id) THEN Destroy_Parameter_ List( pl_id ); END IF; pl_id := Create_Parameter_ List('tempdata' ); Add_Parameter( pl_id,'p_ query1', TEXT_PARAMETER, v_query1); Add_Parameter( pl_id,'p_ query2', TEXT_PARAMETER, v_query2); Add_Parameter( pl_id,'p_ query3', TEXT_PARAMETER, v_query3); Add_Parameter( pl_id,'p_ plan_wo_id' , TEXT_PARAMETER, :PRDPWO01T.PLAN_ WO_ID); Add_Parameter( pl_id,'p_ revision' , TEXT_PARAMETER, :PRDPWO01T.REVISION ); Add_Parameter( pl_id,'DESFORMAT ', TEXT_PARAMETER, 'DELIMITED') ; Add_Parameter( pl_id,'DESTYPE' , TEXT_PARAMETER, 'File'); Add_Parameter( pl_id,'DESNAME' , TEXT_PARAMETER, :parameter.p_ physycal_ dir||v_file) ; v_file := v_file||' Plan WO ['||:PRDPWO01T. PLAN_WO_NO| |'].xls'; run_product( reports, 'PRDPWO01R.RDF' , synchronous, runtime, filesystem, pl_id, null); end; nb : trigger diatas digunakan di When-Button- Pressed, namun sebelumnya gita harus buat suatu report (kalau dari contoh diatas nama file nya PRDPWO01R.RDF) . kemudian yg harus diperhatikan juga oleh gita adalah sintak "Add_Parameter" , sintak ini digunakan untuk memberikan parameter ke parameter report. semoga bermanfaat -Denny Kusumah- --- Gita cantiq <[EMAIL PROTECTED] com> wrote: > Dear Master Oracle, > > Saya mau menanyakan bagaimana cara menggunakan > trigger di form versi 6i patch 14, untuk import > excel file ke type data oracle dan untuk export data > oracle ke excel file. > Jadi saya menggunakan satu button dan trigger yang > digunakan adalah When-Button- Pressed. > > Thanks before, > Gta > > > > ____________ _________ _________ _________ _________ _________ _ > Looking for last minute shopping deals? > Find them fast with Yahoo! Search. > http://tools. search.yahoo. com/newsearch/ category. php?category= shopping > > [Non-text portions of this message have been > removed] > > ____________ _________ _________ _________ _________ _________ _ Never miss a thing. Make Yahoo your home page. http://www.yahoo. com/r/hs ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
