ORA-01866: the datetime class is invalid
Answers were Sorted based on User's Feedback
Answer / guest
Cause: This is an internal error.
Action: Please contact Oracle Worldwide Support.
Please add more information about this Error
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / wells dantas
We had the same error in an application running on Oracle Application Server version 10.1.3.5.0. The application ran without problems in Brazil and we had to migrate it to Mozambique (Africa).
After several unsuccessful attempts, we found that this problem only happened when we used a non-default TimeZone (GMT) and other than "America/Sao_Paulo" (in our case was set for TimeZone "Africa/Maputo"). We found that this problem did not occur in Oracle Application Server version 10.1.3.1.0 with the same settings in TimeZone.
We solve the problem by replacing two libraries of the BC4J version 10.1.3.5.0 to BC4J version 10.1.3.1.0: adfm.jar and bc4jmt.jar.
Our problem was solved by replacing these two libraries, but if replacement is not possible it is best that the matter be reported to Oracle that the problem is resolved.
Regards,
Wells Dantas / Renan Furtado
Accenture Brasil
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anonymous
If using Windows, try:
* In the system registry, go to
HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Controls/TimeZoneInf
ormation
* Remove the DisableAutoDaylightTimeSet property, or set it
to 0.
Is This Answer Correct ? | 1 Yes | 5 No |
IMP-00044: unable to allocate enough memory for statement
NZE-28842: Incorrect file permissions
PLS-00623: FLOAT precision constraint must be between 1 and 126
ORA-07237: slemcl: invalid file handle, seals do not match.
NID-00142: Only changing database name, previous attempt changed dbid to number
IMG-00545: invalid cut values specified
ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
ORA-32307: must use FROM ONLY clause when referencing an object table
ORA-25146: EXTENT MANAGEMENT option already specified
ORA-06907: CMX: error during connect confirmation
ORA-00055: maximum number of DML locks exceeded
TNS-12223: TNS:internal limit restriction exceeded