Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-06-15
3
Medium Priority
?
853 Views
Last Modified: 2010-07-07
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
Comment
Question by:alexapostolou
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 1000 total points
ID: 16919485
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
 

Author Comment

by:alexapostolou
ID: 16932032
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 16932049
glad you got it solved :-))

never guessed this with this special charcters

meikl ;-)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question