Skip to main content
R
ritikas0005
June 8, 2021
Question

How to query data for a field of type clob in Database

  • June 8, 2021
  • 1 reply
  • 0 views

Hi,

I have a requirement where I have to query the data from database for a particular column of type CLOB which has data more than 1 MB and display it in a text file .

While fetching the data from queryEntity it is reaching to memory threshold or it is reading the column data as null while trying to fetch the output directly from store procedure to flat file.

Please recommend me some way of how we can handle large files in Appian.

Thanks in Advance!

    1 reply

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 9, 2021

    This is unclear to me. Is this about displaying > 1MB of text on screen or about writing > 1MB of text from DB into a document? Is each individual field larger than 1MB?

    In general the memory restrictions are quite strict but could be changed. But to what level? Do you know what your upper limit would be?

    Terms & ConditionsAccessibility statement