I would like to display an CLOB in an grid. This grid is READ ONLY.
The problem is, I get an ORA-06502 Error.
Is it not possible to display the CLOB data?
Kind Regards, Christian
Thanks for the test case. I can confirm that the grid does not currently support CLOBs > 32k. We have filed an enhancement request.
I will do so, this should help first.
Thank you Matt
to_char(substr(c.data.getClobVal(),1,4000)) using gives me an ORA-00904: "C"."DATA"."GETCLOBVAL": invalid identifier
Hide the search plugin and use your own external search (page 3003 in the documentation app).
Including CLOB columns in your grid and not restricting their data is a bad idea as performance will suffer greatly since all the CLOB data will be transferred from the server to the browser for every search request, refresh, column filter etc.
Thank you, I will try it.
My apologies, I aliased the column, here is my entire query:
, id idnum
, to_char(substr(c.data.getClobVal(),1,4000)) Data
from v_medtran_tran_xml c
order by 1 desc
I can use the standard grid search function in my read only grid.
Please create a test case on demo.tryfoexnow.com and we will investigate.
see application 368
There you have an CLOB with much data in it.
I just do this:
as I don't want to see ALL the data in the context of grid. That is the workaround I've been using.
But if I reduce the data, I also cannot search in it, am I right?
Is there another possibility to search in the data?