Home » Developer & Programmer » Forms » Any help for the calendar problem
Any help for the calendar problem [message #82515] Mon, 02 June 2003 10:28 Go to next message
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 Go to previous message
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''');
Previous Topic: calling sqlloader from oracle forms
Next Topic: Diff. between object groups and object library
Goto Forum:
  


Current Time: Mon May 16 17:37:06 CDT 2022