I have a problem with inserting a document in a XMLType column. I get the following error message:
ORA-01830: date format picture ends before converting entire input string
I did some searching and the problem is the element which is a dateTime with Timezone information. If the entry
oraxdb:SQLType="TIMESTAMP WITH TIME ZONE"
is added everything is correct.
The problem is that we dont want to edit the XSD because it was standardized. Is there another way to get around this error ( e.g. parameter or column definition, ... ) ?
Greeting
Alex
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production