SQLExec with a LONG Field Caused an Application Server Crash
Solution : Doc ID 2720046.1
LONG fields have been deprecated in PT8.58 and should no longer be used. If you need to use a LONG field, you will need to set the following parameter in the app server config file:
[Database Options]
OracleUseLobLocators=0
As a workaround the LONG field can be converted to CLOB.
This comment has been removed by the author.
ReplyDeleteIt is a workaround that also works for reports launched from a standby in ADG and database 12.1. In 8.58 it no longer works (SQLExec crash with error "ora-22992 : cannot use lob locators selected from remote tables" if you're in 12.1, no error in 18c and above). You must put this parameter in the process scheduler config file to be able to continue launching reports from standby.
ReplyDelete