Re: question regarding xml

"steverourke" <steve750813_at_yahoo.com> wrote in message news:ae45506e.0307311904.4c52e88_at_posting.google.com...
> sorry you guys
> i am very newbie on oracle dbms; i know nothing but some sql
> techniques as far as database. i have a question redarding xml
> theoretically, it should be possible that whatever i put into database
> can be converted to xml, then that xml can be transfered via internet
> to the other part that want to have data - i do know wheter it is
> possible or not.
> am i imagining too much?
> if possible, what would be a way to do so, what techniques?
> thank you

It depends :(

Approaches seem to fall into.

Store data in db, write access layer in programming language (eg java), parse and pass xml around outside Oracle. store xml in db, write access layer in programming language, pass xml around outside oracle
store xml in db, parse xml in db, call stored procs from outside oracle.

etc etc. There is an xml technology centre at otn.oracle.com which seems to concentrate on doing as much as possible in the db.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK