Page tree
Skip to end of metadata
Go to start of metadata

Please be aware of the following restriction and available workarounds in Reporting Area

 

  1. 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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Link: http://wiki.scn.sap.com/wiki/x/DwLvFw

  • No labels