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.
To add functionality to save out a block:
Writes the data from the specified block to a flat file.
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);
NUMBER - 0 for success, -1 for failure.
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. |
Writes the data from the specified block to a file in HTML format.
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 := '')
;
NUMBER - 0 for success, -1 for failure.
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. |