XML manipulation in PL/SQL (non 8i/9i) 
Author Message
 XML manipulation in PL/SQL (non 8i/9i)

Hi all,

Wondering if this is the right group to post to, please advise if otherwise.

I need to be able to manipulate XML messages, either returned as a parameter
from an external procedure call (.so on Unix or .dll on NT) or as persistent
messages (files) from Pl/SQL stored procedures.

This is done for an interface project. The current interface architecture is
based on the exchange of persistent, fixed field length ASCII files between
the interfacing systems, UTL_FILE got me there. The stored procedures were
called from a scheduler, either from Unix scripts running on the crontab or
from batch files on NT, which in turn called sqlplus to run anonymous bloks.
The idea is to preserve this way of running the stored procedures, obviously
not necessarily using UTL_FILE.

I am aware that I could accomplish just that, using 8i/9i server and the XDK
for Pl/SQL. Problem is: I may not have this option, as this is a big
customer with its own standards and does not upgrade easily its IT
infrastructure.

What I'm asking is then: is there a way to manipulate XML in Pl/SQL on
Oracle 7.3.4. and/or 8.05, e.i. short of writing my own parser?

I'm thinking on the lines of being able to access Java classes from stored
procedures, which is apparently what 8i/9i can do.

Any insight much appreciated.

Regards,
Radu Lascae



Wed, 24 Mar 2004 17:26:53 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. DB Link from 8i to 9i using XML

2. US-DE: Wilmington-Strong Oracle 8i/9i Programmer with XML

3. Should I study Oracle 8i/9i or 9i directly/

4. Anyone need 8i/9i or upgrade to 9i OCp

5. file manipulation in pl/sql

6. PL/SQL String Manipulation Problem?

7. SELECT FOR XML RAW|AUTO generates non-compliant XML

8. Comparision of Sql server 2000 and Oracle 8i or 9i

9. US-GA-SQL SERVER 2000/7/6.5 AND ORACLE 9I/8I/7.X PRODUCT

10. HELP: Oracle 8i vs 9i vs MS SQL 2000

11. Oracle 8i or 9i vs SQL Server

12. XML support in Oracle 9i and SQL Server 2000


 
Powered by phpBB® Forum Software