October 25, 2007, 05:00 AM
johneyOracle package call from a button click
Hi All,
I have a requirement to call an Oracle stored Package from a button click of FEX.This button was created using HTML+Javascript inside a
-HTMLFORM BEGIN tag in the same FEX.
I dont want to call another FEX using xml-regestes to achieve this, because I have a textarea value to be passed to the Oracle package (without losing its formats) and I found it is not possible to pass a textarea value directly to another FEX (copying its value in a text box and we can pass but the formattig will be lost in that case).
Any suggestions?
November 12, 2007, 01:50 AM
johneyHi All,
Can I call the same procedure again (recurring call) with the button click event in the FEX . I know we can call the procedure again from the hyperlink with the use of styles as below.
TYPE=HEADING,LINE=10,ITEM=1,TARGET='_self',FOCEXEC=MYFOCFEX(BILL_MONTH=&BILL_MONTH OCMCMPR='&OCMCMPR' BUSGRPR='&BUSGRPR' BUSUNTR='&BUSUNTR' SITER='&SITER' BLDGR='&BLDGR' FLRR='&FLRR' RPTLVL='&RPTLVL' FMT='EXL2K'),$
(It is a drilldown of the same report based on the header click)
Can I do this procedure call from the button click event in the same FEX ?
Regards,
Johney.