The example schema:
<elementtest>
<element1>1</element1>
<element2></element2>
<element3>3</element3>
</elementtest>
is a perfect example of what the schema should look like. I cannot post the schema for the document is classified, hence the use of 'element1' and the like instead of...
I have a VB.net application that I am pulling a webservice XML, and then reading it into an adapter that will push the records into a Sql Server database with the same schema as the database table it is writing to. My code works on well formed XML, the only problem is that the XML from this one...
Sounds great! I have tried googling this and can't find a specific example...would you mind posting some sample syntax for the ODBC connection part? Can this work with a JDBC connection as well?
Thanks a lot!
Hello,
I want to write a java application that pulls multiple records from SQL Server and then updates records onto an Oracle 9i database. What is the best way to do this? Would it be best to call the SQL Server, write it to XML and then somehow iterate through the xml through an Oracle...
I've read some articles about XDB and XMLTYPE for Oracle 9i, and found one where you can parse static xml code in the Stored Procedure to write into a database table, but what I really want to find is a simple example of parsing an existing XML document inside an Oracle 9i Stored Procedure, then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.