Re: FORMS_DDL question

Hi,

You could put the next 2 undocumented commands in your when-new-form-instance trigger

set_application_property(builtin_date_format,'DD-MON-YYYY'); set_application_property(plsql_date_format,'DD-MON-YYYY');

The latter will solve your problem (forms 5.0).

Hope this helps

Wim

wozi <wozi_at_dhc.net> wrote in article
<339FE9E9DD87FECC.19392F0BF1548942.85A8E95CDB42BE8B_at_lp.airnews.net>...
> I have the following in pre_form trigger:
>
> FORMS_DDL('alter session set nls_date_format=''DD-MON-YYYY
HH:24:MI:SS''');
>
> When I based a multi-record block on the system view
nls_session_parameters
> so that I can see the settings for date format,
> I get NLS_DATE_FORMAT DD-MON-YY
>
> This should have been DD-MON-YYYY.
>
> Thanks for any assistance.
>
>
>
>
Received on Mon Dec 06 1999 - 15:47:14 CET