Any help for the calendar problem [message #82515] |
Mon, 02 June 2003 10:28 |
Vinod
Messages: 76 Registered: April 1999
|
Member |
|
|
Hi all,
we are running forms application on the web and using 6i with all the latest patches.
we have implemented the calendar functionality in our application. problem is that we have been facing some inconsistent problems while using the calendar like
1) some times i get the error FRM-40509: oracle error:unable to update record
ORA-01483: invalid length for DATE or NUMBER bind variable when i try to save the record after selecting the date from the calendar
2) returning the wrong date format to the item from calendar(only sometimes)
I get the above problems only some times and not all the time. I am not able to find out the reason for this erratic behaviour
For your information we have the date items with format mask MM/DD/RRRR
Any help please
Vinod
|
|
|
Re: Any help for the calendar problem [message #82606 is a reply to message #82515] |
Thu, 12 June 2003 07:37 |
sameer_am2002
Messages: 129 Registered: September 2002
|
Senior Member |
|
|
Try something this on pre-form
set_application_property(DATE_FORMAT_COMPATIBILITY_MODE, '5.0');
set_application_property(PLSQL_DATE_FORMAT, 'YYYY/MM/DD HH24:MI:SS');
set_application_property(BUILTIN_DATE_FORMAT, 'YYYY/MM/DD HH24:MI:SS');
forms_ddl('ALTER SESSION SET NLS_DATE_FORMAT = ''YYYY/MM/DD HH24:MI:SS''');
|
|
|