Orasource - Reporter Handler for oracle connection


NAME

Orasource - Reporter Handler for oracle connection


SYNOPSIS

        use Data::Reporter::Orasource;
        $source = new Data::Reporter::Orasource(File => $file,
                                Arguments => $info,
                                Query => $query);
                $file           - information file about connection login
                $info           - array reference (usr, pwd, db, srv) about connection login
                $query          - query to execute for getting data
        $subru = sub {print "record -> $_\n"};
        $source->getdata($subru);


DESCRIPTION

new()
Creates a new handler to manipulate the oracle information.

$source->configure(option => value)

valid options are:

File Information file about connection login. The file must have the following information: user, password, database, server. These items must come in this order, each on a separate line.

Arguments array reference with the following information: usr, pwd, db, srv. This can be used instead of the File option

query string with the query to execute to retrive the data

$source->getdata($subru)
For each record of the query result, calls the function $subru, sending the record as parameter


AUTHOR

        Vecchio Fabrizio <jacote@tiscalinet.it> FABRVEC

 Orasource - Reporter Handler for oracle connection