Skip to Main Content

APEX

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!

APEX_DATA_EXPORT.ADD_COLUMN p_is_frozen not working

Jon Dixon2 hours ago

I am using apex_data_export.add_column as below. The problem is, no matter which column I put the p_is_frozen flag in, it always freezes just the first column in Excel. If I exclude p_is_frozen, then no column is frozen, but when I include it, it always freezes the first column.

apex_data_export.add_column(p_columns => lt_columns, p_name => 'NODE_CODE', p_heading => 'Node Code');
apex_data_export.add_column(p_columns => lt_columns, p_name => 'NODE_NAME', p_heading => 'Node Name');
apex_data_export.add_column(p_columns => lt_columns, p_name => 'SYSTEM_NAME', p_heading => 'Source System Name');
apex_data_export.add_column(p_columns => lt_columns, p_name => 'POSTABLE_FLAG', p_heading => 'Postable Flag');
apex_data_export.add_column(p_columns => lt_columns, p_name => 'ACTIVE_FLAG', p_heading => 'Active Flag', p_is_frozen => TRUE);
Comments
Post Details
Added 2 hours ago
0 comments
10 views