Main Region

Display CLOB in Grid
4 answers | 540 views
CH
Christian86
Jul 23, 2015 11:56 +00:00

Hello

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

7 comments
MN
Matt Nolan Jul 23, 2015 14:17 +00:00 

Thanks for the test case. I can confirm that the grid does not currently support CLOBs > 32k. We have filed an enhancement request.

CH
Christian86 Jul 24, 2015 04:19 +00:00 

Hi

I will do so, this should help first.

Thanks

Christian

CH
Christian86 Jul 24, 2015 04:20 +00:00 

Thank you Matt

CH
Christian86 Jul 24, 2015 05:17 +00:00 

to_char(substr(c.data.getClobVal(),1,4000)) using gives me an ORA-00904: "C"."DATA"."GETCLOBVAL": invalid identifier

MN
Matt Nolan Jul 24, 2015 07:22 +00:00 

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.

CH
Christian86 Jul 24, 2015 07:30 +00:00 

Thank you, I will try it.

CH
Chris Jul 24, 2015 13:00 +00:00 

My apologies, I aliased the column, here is my entire query: select id , id idnum , tran_type , rec_date , 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.

MN
Matt Nolan
Jul 23, 2015 12:05 +00:00

Please create a test case on demo.tryfoexnow.com and we will investigate.

0 comments
CH
Christian86
Jul 23, 2015 12:22 +00:00

see application 368 There you have an CLOB with much data in it.

0 comments
CH
Chris
Jul 23, 2015 14:28 +00:00

I just do this:

to_char(substr(c.data.getClobVal(),1,4000)) Data

as I don't want to see ALL the data in the context of grid. That is the workaround I've been using.

Thanks,

Chris

0 comments
CH
Christian86
Jul 24, 2015 05:08 +00:00

But if I reduce the data, I also cannot search in it, am I right? Is there another possibility to search in the data?

0 comments
You must log in or sign up to post questions and answers.