Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

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
41
Views
1
Comments
User_4QJWE
User_4QJWE Rank 1 - Community Starter
edited Jan 10, 2025 12:41PM in Oracle Analytics Forum

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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?