There is a problem with the SYSDATE time due to the database time zone settings, until the session is configured:
ALTER SESSION SET SYSDATE_AT_DBTIMEZONE=TRUE;
If I want to solve this setting in the database logon trigger:
CREATE OR REPLACE TRIGGER logon_trigger_timezone
AFTER LOGON ON DATABASE
BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET sysdate_at_dbtimezone=true'; END;
Then ORDS does not work: HTTP Status Code: 571
Is there a way to set the database timezone without session configuration so that both ORDS and SYSDATE work?