Focal Point
Oracle package call from a button click

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5381037352

October 25, 2007, 05:00 AM
johney
Oracle 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?


Version 7.6.11
Webfocus installed in AIX 5.3,
desktop PC: Windows-XP based
Output: Excel, HTML, PDF
November 12, 2007, 01:50 AM
johney
Hi 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.


Version 7.6.11
Webfocus installed in AIX 5.3,
desktop PC: Windows-XP based
Output: Excel, HTML, PDF