Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to use HTML Tags inside UTL_FILE.fopen

John ManlyJul 9 2019 — edited Jul 9 2019

Hi,

12.1.3 -- We are writing the sql data as .xls file and trying to add the color to the table Header.

Below is the table Header Details which we wanted to be in different background color to differentiate the header and the data ,but when we use HTML Tags, the header details color not appearing  instead the HTML Tags are getting printed.

v_file_name:=  l_File_nm ||'.xls';

v_file := UTL_FILE.fopen (v_path, v_file_name, 'w', 32767);

l_Header :=

                          'Type '

                      || CHR (9)

                      || 'Name '

                      || CHR (9)

                      || 'Item Type '

                      || CHR (9)

                      || 'Line / Product '

                      || CHR (9)

                      || 'Item Description '

                      || CHR (9)

                      || 'Quantitiy '

                      || CHR (9)

                      || 'UOM '

                      || CHR (9)

                      || 'Price '

                      || CHR (9)

                      || 'Amount '

                      || CHR (9)

                      || 'Associated Earnings Flag '

                      || CHR (13);

      UTL_FILE.put_line (v_file, l_Header);

Any help is highly appreciated.

Regards,

John.

Comments
Post Details
Added on Jul 9 2019
9 comments
715 views