xml and perl

[moof15]

Does anyone have a script that I could load data into a oracle database using a .dmp file.

Thanks,
Moof15

 

[MattMcGinnis]

Hmmmmm. Your subject is "XML and perl" but your question is about Oracle and .dmp files. Have you converted the dmp file to an XML document?

You could use a combination of an XML module (I think XML::Simple would work) and the ODBC module to 1.parse the info from the XML doc and 2.insert the info into Oracle.

It all depends on the format of the dmp file, the structure of your table, and what info you WANT to put in the database. I don't think you are going to find a script which will do exactly what you want, but you may find something to customize. Actually, it might just be easier to write the whole thing using the modules.

Maybe if you provide more info, someone here can help you.

MattMcGinnis

 

[moof15]

Matt,

Can I call the .dmp in the xml file as for example:

<trainpath>oraclefiles/TRAINING.dmp</trainpath>

 

[moof15]

<execute> <trainpath>oraclefiles/TRAINING.dmp</trainpath>
</execute>

Will this work? if i put it in a .xml? If the database is already connected.

Moof15