problem with validating date Time in xml document
I have serwer in version 11.2.0.3 migrated from 10.2.x.x
Now, when i try to set value of xmlType column with locally register schema I get xpath error (on date time value)
Problem is date format. When i try format "yyyy-mm-dd hh24:mi:ss.ff" like on 10.2. version i have error. If I change date to format yyyy-mm-dd hh24:mi:ss,ff update works fine.
My nls settings:
from nls_database_parameters
| NLS_CALENDAR | GREGORIAN |
| NLS_CHARACTERSET | AL32UTF8 |
| NLS_COMP | BINARY |
| NLS_CURRENCY | $ |
| NLS_DATE_FORMAT | DD-MON-RR |
| NLS_DATE_LANGUAGE | AMERICAN |
| NLS_DUAL_CURRENCY | $ |
| NLS_ISO_CURRENCY | AMERICA |
| NLS_LANGUAGE |
0