The Save2HTML (frmutil) Reusable Component

This Component consists of a PL/SQL library which has functions to write the contents of a specified block to a flat file, either in HTML format or as plain text.

Using the frmutil Component

To add functionality to save out a block:

  1. Attach the PL/SQL library frmutil.pll, which contains the F90WRITE package, to your module.
  2. Call the F90WRITE.Write_Block or F90Write .Write_HTML functions from your code.

F90Write Routines

F90Write.Write_Block  

Description 

Writes the data from the specified block to a flat file.

Syntax

FUNCTION F90Write.Write_Block( block_name    VARCHAR2, 
output_file VARCHAR2 := 'output.lis',
output_mode VARCHAR2 := 'W',
column_align BOOLEAN := TRUE,
sep_char VARCHAR2 := ' ',
rec_option VARCHAR2 := 'ALL',
displayed_only BOOLEAN := FALSE);

Returns

NUMBER - 0 for success, -1 for failure.

Parameters

block_name The name of the block to write to the flat file
output_file The full name of the output file, including any path and file extension. Note that this file will be written on the middle tier machine running Forms Services.
output_mode The output mode. Specify W for write or A for append.
column_align column-align the data in the output file.
sep_char The character string that will separate columns in the output file.
rec_option Determines which records are written. Valid values are ALL, VIEWED, and DISPLAYED.
displayed_only Should all items or only displayed items be written to the output file.

F90Write.Write_HTML 

Description 

Writes the data from the specified block to a file in HTML format.

Syntax

FUNCTION F90Write.write_html( block_name      VARCHAR2,
output_file VARCHAR2 := 'output.html',
rec_option VARCHAR2 := 'ALL',
displayed_only BOOLEAN := TRUE,
include_date BOOLEAN := TRUE,
bookmark_title VARCHAR2 := 'Oracle Developer',
include_image VARCHAR2 := '')
;

Returns

NUMBER - 0 for success, -1 for failure.

Parameters

block_name The name of the block to write to the flat file
output_file The full name of the output file, including any path and file extension. Note that this file will be written on the middle tier machine running Forms Services.
rec_option Determines which records are written. Valid values are ALL, VIEWED, and DISPLAYED.
displayed_only Should all items or only displayed items be written to the output file.
include_date A boolean indicating whether or not to write the current date and time to the HTML file.
bookmark_title The HTML bookmark title. This is not visible when viewing the file in a browser, but is used when setting a bookmark for the page.
include_image The name of an image file that will be included at the top of the HTML file when viewed. It is recommended that you do not include a path when specifying the file name.