how to change the date format using initSQL from weblogic console (Doc ID 2238653.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.

Goal

How to enable the feature of Initializing Database Connections with SQL Code


As documented in "https://docs.oracle.com/middleware/1212/wls/JDBCA/jdbc_datasources.htm#JDBCA159", WebLogic Server runs SQL code using Init SQL attribute on the JDBC Data Source: Configuration: Connection Pool page in the Administration Console whenever it creates a database connection for the data source, which includes at server startup, when expanding the connection pool, and when refreshing a connection.

But This feature did not work for the below query

SQL alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

The same feature is working for Oracle forms and Reports


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms