Please be aware of the following restriction and available workarounds in Reporting Area
- Using SELECT * FROM <tablename>
By default you can’t query tables with COLUMNs having CLOB or BLOB datatype in Plateau Report Designer (PRD). It is the nature of the reporting with CLOB or BLOB fields.
Workaround: Define ALL the COLUMN that you are interested in the SELECT statement excluding the CLOB/BLOB column. This does not mean you can’t query COLUMNs having CLOB or BLOB datatype. You need to use the cast function. Example as shown in below example,
select utl_raw.cast_to_varchar2(dbms_lob.substr(AICC_CORE_VENDOR2,4000,1)) as aicc_core_vendor2 from PA_CBT_APPLICATION.
2.