Ricardo Vazquez Armenta > Data-Reporter-1.4 > Data::Reporter::Orasource

Download:
Data-Reporter-1.4.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

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
syntax highlighting: