My Oracle Support Banner

BI Publisher Throws " IO Exception" When URL Is Used on Null Column (Doc ID 2919651.1)

Last updated on JANUARY 16, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 and later
Information in this document applies to any platform.


BI Publisher throws IO Exception when URL is used on null column.


   1. Go Catalog and create a new data model based on below sample SQL Query:

Select test test, some text ||chr(10)||with line brake text, 1 rn, sysdate mydate from dual
union all
Select test, some text ||chr(10)||with line brake text, 2 rn, null mydate from dual

   2. Add Parameter P_TEST.

   3. View; Save As Sample Data;Save; Create Report Wizard : Select Data : Next
Select Layout: Next.

   4. Create Table: Add all columns; Next.
Save Report: Finish.
Save as: RE_NULL_Record; OK.
Interactive View - Will Show two Records in Interactive View (Which is correct).
HTML view – Will show two records and also Line brake.
Edit Layout.

   5. Select Test Column data; Enter URL:



  6.1. Error : Interactive report shows only 1 row.

  6.2. Error : HTML view shows Error:

  6.3. PDF View shows the same error.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.