Re: Oracle trigger and XML file

Prasad,

I believe the XDK for PL/SQL is already loaded in Oracle9i (it was on our Solaris and Win2K instances). The way you can tell is to look for packages like XMLDOM, XMLPARSER, XMLGEN, etc. It was mainly in 8i where you needed to load the XDK yourself...

Hope this helps,
-Dan
http://www.compuware.com/products/numega/dbpartner/dbpordebug.htm Debug PL/SQL and Java in the Oracle Database

"Prasad" <pr_kale_at_yahoo.com> wrote in message news:9e62bcff.0202070622.1345412_at_posting.google.com...
> I am using oracle 9.0.1. I tried to install XDK for PL/SQL. Can this
> utility be installed from client system or it has to be installed on
> the database only?. I tried to install this utility from client system
> but came across lot of problems. I assume user needs to have some
> rights to install this utility, if he has to install it from his
> login/password.
>
> Is there any detailed documentation as how to go about installation
> of XDK for PL/SQL on oracle 9.0.1?
>
> Thanks for the responses.
> PK
>
>
> pr_kale_at_yahoo.com (Prasad) wrote in message
news:<9e62bcff.0202040640.2f273698_at_posting.google.com>...
> > I have a need to create a XML file from table data. Each time data in
> > a table changes, XML file reflecting the table data should be
> > overwritten. For this i am hopeful of using oracle triggers. Is there
> > a way to create XML files from PL/SQL?.
> >
> > Any ideas are welcome.
> >
> > Thank you.
Received on Thu Feb 07 2002 - 12:43:23 CST