Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

date format picture ends before converting entire input string

15060Nov 9 2005 — edited Nov 14 2005

I've managed to create a xmltype in PL/SQL containing XML that has lots of <xsd:dateTime> content in it.

However, when I try to insert the data in the XDB generated table from the schema, I get a 1830 error: date format picture ends before converting entired input string.

That's all ;) My XML is more than 100000 lines long - I have no clue where the problem lies? The dates have the same format, as when I create XML from within the xmltype. I've tried with and without timezone - same result. I get a refernece to XMLTYPE line 348 - but of course, I don't have the source code ;)

Can anyone help me here?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2005

Added on Nov 9 2005

#performance-availability, #xml-db

3 comments

3,339 views