I had faced a problem in viewing the CLOB type data in a model.
On right clicking the table and view data, it throws an error if the table contains CLOB (rawXML) content.
To resolve the above issue,
In odiparamas.bat file set the below parameter
set ODI_ADDITIONAL_JAVA_OPTIONS=%ODI_ADDITIONAL_JAVA_OPTIONS% " -Doracledatabasemetadata.get_lob_precision=false"
next to,
set ODI_ADDITIONAL_JAVA_OPTIONS="-Djava.security.policy=server.policy"
Restart the ODI and now able to see the data..!! :)
On right clicking the table and view data, it throws an error if the table contains CLOB (rawXML) content.
To resolve the above issue,
In odiparamas.bat file set the below parameter
set ODI_ADDITIONAL_JAVA_OPTIONS=%ODI_ADDITIONAL_JAVA_OPTIONS% " -Doracledatabasemetadata.get_lob_precision=false"
next to,
set ODI_ADDITIONAL_JAVA_OPTIONS="-Djava.security.policy=server.policy"
Restart the ODI and now able to see the data..!! :)