How can I add a CLOB field in Jaspersoft Studio and display it as String in the report in Clarity?

book

Article ID: 144581

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

I am trying to add CLOB field in Jaspersoft Studio, when I look in the report it just shows an Oracle field reference but not the actual text value. How can I display the file as a String?

Environment

Release : All Supported Releases with Clarity

Component : CA PPM JASPERSOFT

Resolution

There are few things you can do to call the field and convert to String. We recommend using Java as described here:

https://community.jaspersoft.com/questions/538454/how-convert-clob-varchar2

Check out the attached file for an example how it will look into Studio.

Attachments

1581006004659__OracleClobTest.jrxml get_app