Clob selection in Data model

acmhari

Summary:

Selecting CLOB column in data model SQL

Content (required):

Team,

I want to fetch a clob column completely in a report using data model SQL. I tried using DBMS_LOB and this does not give data more than 4000. Is there any other way to fetch full CLOB details in column ?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Sujeeth Chinta

Hi @acmhari

Are you able to find on how to fetch CLOB column ?

I had the same issue now. If you were able to fetch it. Please let me know the steps It would be very helpful to me.