Hi
In my application, I need to show the value of a database column that is of type CLOB. To do so I have created a page ITEM of type "Display Only" with "SQLquery" as source. The query looks like something like this:
select doc_comments from mydocuments, where doc_id= <some bind variable>
The item displays fine as long as the size of the CLOB column above is less than 4k. with a content greater than 4k , the display item shows a blank area.
In my case, The size of CLOB will not exceed 32 K . somewhere between 4-10 K
I have done another test that I created an item with the following PL/SQL function body but it didn't work either:
DECLARE
L_clob CLOB;
BEGIN
select doc_comments INTO l_clob from mydocuments, where doc_id= <some bind variable>
:P9_COMMENT := L_clob;
end;
:P9_COMMENT is the name of my "Display Only" item.
Could someone please point out what I am missing here? How can I achieve my goal?
Thanks,