We are strarting using Oracle.
I want to set a specific NLS_DATE_FORMAT to use in Oracle JDBC adapter inside Integration Server.
Reading driver information I verified that even if the driver is thin or OCI it will generate different nls_session_parameters and I am not able to change this.
I have tried doing “ALTER SESSION SET NLS_DATE_FORMAT=‘YYYY-MM-DD HH24:MI:SS’” and everything worked ok. But I need to find another solution that guarantees working with “Connection Pooling” inside Integration Server.
I tried to set Environment Variables in Windows but without Sucess.
Any suggestions ?