Does anyone here know a good integration method

[Patros]

for oracle8 and XML and perhaps some good examples. I have been trying ASP but am stuck at a preliminary stage and was hoping perhaps I can try a different method.
Thanks in advance
Patros

 

[spenglerr]

Oracle 8 or Oracle 8i??

 

[Patros]

It's oracle 8i

 

[spenglerr]

Hi,

sorry but I was out of internet on the weekend.

You can use the Oracle XDK. You can download it at technet. There are different possibilities how you can implement the Oracle XDK. It's up to you in which language you will program it:

XDK for PL/SQL
XDK for Java
XDK for C

Actually I used the XDK for PL/SQL and made very good experiences with it. Don't be afraid of using the XDK 9i, since it is compatible with the Oracle 8.1.6 ff -versions.
It is quite easy to use, gives good error handling and examples. We also used in the beginning the samples from O'Reillys book Building Oracle XML Applications. These samples can be downloaded from:

http://www.oreilly.com/catalog/orxmlapp/

try the examples-link.

It is also somewhat of a beginners guide to Oracle XDKs.

In the meantime we switched from DOM-parsing using PL/SQL to the SAX-parsing, which is described in the article of Jinyu Wang in the Oracle Technet. A very good article, since we also got problems with the very slow DOM-parsing when parsing XML-files into the Oracle-database.

 

[sem]

Can you provide an URL for SAX-related article?

 

[spenglerr]

Hi sem,

the URL:

http://otn.oracle.com/tech/xml/xdk_sample/xdksample_040602i.html

regards

 

[sem]

Thank you a lot