In certain configurations it may be necessary to run specific SQL statements or set database specific options each time a connection to a database is established.
The configuration file âOracle.xmlâ contains parameters that control connections made to Oracle. The following configuration directives are supported:
InitSQL â specify a line of SQL that will be run each time a new connection to Oracle is established. There is no limit to the number of InitSQL elements.
The following Oracle.xml file will cause CopyStorm to run the command:
alter session set â_optimizer_rownum_pred_based_fkrâ=FALSE
Oracle.xml:
<Oracle>
<InitSQL sql="alter session set "_optimizer_rownum_pred_based_fkr"=FALSE" />
</Oracle>