mailme0205 has asked for the wisdom of the Perl Monks concerning the following question:

Greetings, We have requirement were we need to populate an Oracle table directly from XML. We thought of using perl module XML:RDB ver 1.3 for the same but wasnt able to install the Module. Details are:- Perl used:- Active perl 5.10.1 build 1007. Platform:- Windows. Error:-1) The module doesnot appear in the list of All available modules when searched from Active perl Manager even after adding the supporting directories. Please let us know:- 1) How can we install n use the mention module XML::RDB on Active Perl for win32. 2) Is there any other available module that can be used with active perl for windows to load data into oracle tables directly from XML source. Appreiate your help. Regards Deep

Replies are listed 'Best First'.
Re: Module XML::RDB
by toolic (Bishop) on Mar 11, 2010 at 17:41 UTC
Re: Module XML::RDB
by ikegami (Patriarch) on Mar 12, 2010 at 08:14 UTC
    cpan XML::RDB

    With a sufficient recent cpan, that will automatically provide build tools if you don't have them.

Re: Module XML::RDB
by dHarry (Abbot) on Mar 12, 2010 at 08:05 UTC

    What version is your Oracle database? With the newer versions there are several ways of loading XML, e.g. SQL*Loader. I'm sure there are more Oracle ways of doing it.

      We are using Oracle 10G as our tgt database. We tried searching it through the all packages in the cpam through PPM but this module doesnt showup in the list.