Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_scheduler and wrong time zone

user461852Apr 23 2025

Oracle 23 Free has error in dbms_scheduler. The session started from dbms_scheduler has no time zone set. It's UTC0 and no way to change it in job definition. I found only one way how corrected it: ALTER SESSION.

  • job start at correct time (UTC+2 for example)
  • session itself has incorrect time (UTC0)

Can this be fixed somehow?

Comments
Post Details
Added on Apr 23 2025
2 comments
127 views