Clob selection in Data model

Question

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):

Sumanth V -Oracle · Answer

@SNG01 - This thread is quite old. Please create a new post in the community with all the details of your requirement. This will ensure it is noticed by more community users and you receive better responses to your query. Thank you

SNG01 · Answer

I am facing the same issue. Need the full value of Clob column and remove the HTML tags.

Sujeeth Chinta · Answer

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.