Oracle Forms

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!

Can I set nls_date_format in default.env?

juliojgsApr 21 2014 — edited Apr 21 2014

I'm migrating from 6i to 11g.

I've found this at the beginning of the main menu of my app:

forms_ddl('ALTER SESSION SET NLS_DATE_FORMAT = ''DD-MM-RRRR HH24:MI:SS''');

which I don't like for obvious reasons, but I also don't dare to remove, as it is the kind of thing that can explode later at runtime, with badly coded triggers using implicit conversion.

Can I set it in default.env?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2014

Added on Apr 21 2014

#forms, #moved-from-devops

2 comments

1,604 views