Hi,
I have a table test that contains the following fields:
id NUMBER,
resp CLOB
Now resp column contains huge data for a particular id.
How do I show clob data(resp) in Oracle forms 6i?
I have 2 solutions at hand:
Solution 1) Create a base table block & set the resp item property to LONG with size as 240.
Solution 2) Convert CLOB to VARCHAR2 & then display the VARCHAR2 in forms. However VARCHAR2 limits the data to 32767 in PLSQL.
I need to display the data formatted as follows, so I cannot use Base table approach:
id -> 3
resp
-----------------------
id -> 2
resp
----------------------
id -> 1
resp
--------------------
I need to display the CLOB data in forms in the above formatted manner in a multi-line text item.i,e Last entry in table is displayed first & so on.
Is this possible with a Base Table?
Thanks