FORMS_DDL question

From: wozi <wozi_at_dhc.net>
Date: Sun, 5 Dec 1999 08:20:47 -0800
Message-ID: <339FE9E9DD87FECC.19392F0BF1548942.85A8E95CDB42BE8B_at_lp.airnews.net>



[Quoted] I have the following in pre_form trigger:

FORMS_DDL('alter session set nls_date_format=''DD-MON-YYYY HH:24:MI:SS''');

[Quoted] When I based a multi-record block on the system view nls_session_parameters [Quoted] 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 Sun Dec 05 1999 - 17:20:47 CET

Original text of this message