• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 864
  • Last Modified:

Using Delphi 7 to insert XML into an Oracle 10g XMLTYPE field gives ora_21500 Internal Error

Hi Experts,

We have an urgent one here:

Using Delphi 7 with Direct Oracle Access 4.0.7.1, we are trying to insert an XML string into an Oracle 10g XMLTYPE data field and it is returning the errors:
"ORA-21500 Internal Error" and then it gives "OCI-21500 Internal Error".

Your immediate help would be very much appreciated.

Cheers,
Alex
0
alexapostolou
Asked:
alexapostolou
  • 2
1 Solution
 
kretzschmarCommented:
well no experience using this via doa,

but i usual do prestore the xml-doc into a clob-field,
there is included a after insert-trigger on the table,
which does then a validation of the doc against a schema
and transfers it, if valid, into the xmltype-field,
otherwise a invalid-flag will be set on the table

of course this is only a workaround in your case

meikl ;-)
0
 
alexapostolouAuthor Commented:
We have found that Oracle's XMLTYPE field (10g) does not permit ascii chars 17 through 22 so these have to be removed from the XML before trying an insert into the field. Thanks for your time.

Alex
0
 
kretzschmarCommented:
glad you got it solved :-))

never guessed this with this special charcters

meikl ;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now