APEX

Hello,

I'm using Apex 4.2 and Oracle 11.g

I have a column called "Transaction Detail" that I display in an interactive report.  The report column's Display Text As selection is set to "Standard Report Column". 

The report column is selected from a varchar2 table column called transaction_detail.  I'm just building the table as well.  The transaction_detail table column is populated from a Procedure with the following code: 

Insert into mail_log (transaction_type, transaction_detail)

Values ('FTP Transaction',

           'Filename=' || p_image_filename || 

                '<br/>' || 'Event Description=' || l_event_description);

The procedure code can be easily changed.

The report just displays: Filename=myfile.jpg<br/>Event Description=my description

I've tried using CHR(13) in the procedure instead of the html characters and then tried to replace the CHR(13) in apex with html characters.  Instead of simply selecting the column:

      , transaction_detail

I tried:

     , REPLACE(transaction_detail, CHR(13), '&lt;br/&gt;')

but I couldn't get past an Apex error: ORA-12899: value too large for column "APEX_040200"."WWV_FLOW_WORKSHEET_COLUMNS"."DB_COLUMN_NAME" (actual: 49, maximum: 30)

Shouldn't Apex be able to interpret the <br/> as a new line if the column is a Standard Report Column?

Thanks for looking at this.