Oracle Developer Forms and Reports

Create MS-Word document from Developer Forms

DECLARE — Declare the OLE objects MyApplication OLE2.OBJ_TYPE; MyDocuments OLE2.OBJ_TYPE; MyDocument OLE2.OBJ_TYPE; MySelection OLE2.OBJ_TYPE; — Declare handle to the OLE argument list args OLE2.LIST_TYPE; BEGIN — Create the Word.Application object and make Word visible — by setting the ‘Visible’ property to true MyApplication := OLE2.CREATE_OBJ(‘Word.Application’); OLE2.SET_PROPERTY(MyApplication, ‘Visible’, 1); — get a handle on Documents collection…

Create a report of a Forms item and block properties

— Hardcoded path + name of output-file; alter if necessary l_temp_filename VARCHAR2(255) := ‘C:\temp\’||:SYSTEM.current_form||’_fmb_blk_items.txt’; l_tabular BOOLEAN := NVL(p_tabular_format, FALSE) ; — Constants below specify the column width for the various columns — The values are pretty small (maybe too small in certain cases), but — in most cases the output is more readable with not…