Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Handling CLOB data in Oracle Analytics Cloud(OAC) and BI Publisher

Received Response
31
Views
1
Comments
User_4QJWE
User_4QJWE Rank 1 - Community Starter

Hi,

I have a CLOB field in which one of the values has maximum of 18000 chars in my Oracle database. Basically, this CLOB field will have some notes, some links, or more than 1 link (using space / [\n] new line characters). So, now when I query this in OAC and export the report to an rtf template, the CLOB field is coming in multiple rows for a single record because of the space and new line characters being used in the CLOB field. How to resolve this either in OAC or BI Publisher.?

In the image below, the two links belong to name 'POC'. Since it has space between them, it comes in 2 rows. But it should come in as in the second image

Appreciate your help, Thanks!

image.png

Second Image:

image.png

Answers

  • Hi,

    Just to clarify: are you asking only about Publisher? Or Publisher and also a "classic" analysis exported as Excel or a DV workbook exported as Excel?