Tuesday, December 12, 2006

Oracle Reports:Convert a rdf to XML for extracting information

At times, we may need to extract information from an oracle report (i.e an .rdf file). Its not easy to read the contents of the .rep and parse because of its nature of plain text.

$ORACLE_HOME/bin/rwconverter scott/tiger@sid stype=rdffile source=MYRDF.rdf dtype=xmlfile dest=MYRDF.xml batch=yes overwrite=yes

After then, either apply an XSL to the XMl to present the data in an HTML format
or parse the XML file to extract the required information and print/store.

1 comment:

Saurabh Agarwal said...

Where we need to run this command
"$ORACLE_HOME/bin/rwconverter scott/tiger@sid stype=rdffile source=MYRDF.rdf dtype=xmlfile dest=MYRDF.xml batch=yes overwrite=yes"