The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

Maplat::Web::OracleDB - Web module for accessing Oracle databases

SYNOPSIS

This module is a wrapper around DBI/DBD::Oracle.

DESCRIPTION

With this web module, you can easely maintain connections to multiple databases (just declare multiple modules with different modnames).

Configuration

        <module>
                <modname>maindb</modname>
                <pm>OracleDB</pm>
                <options>
                        <dburl>dbi:Oracle:dbname=Maplat_DB</dburl>
                        <dbuser>Maplat_Server</dbuser>
                        <dbpassword>SECRET</dbpassword>
                </options>
        </module>

dburl is the DBI connection string, see DBD::Oracle.

AutoCommit

Get/Set the DBD::Oracle "AutoCommit" setting

RaiseError

Get/Set the DBD::Oracle "RaiseError" setting

errstr

Get the DBI errorstring.

do

Execute a DBI statement with "do"

prepare

Prepare a (non-cached) Statement.

prepare_cached

Prepare a server cached statement (may fall back to non-cached transparently, see DBD::Oracle and Oracle documentation for details).

quote

Quote a variable for use in Oracle statements.

commit

Commit transaction.

rollback

Rollback transaction.

checkDBH

Internal function. Checks if the database handle is valid and reconnects if needed.

Dependencies

This module is a basic module which does not depend on other web modules.

cleanup

Internal callback function, makes sure there are no open transactions after rendering a page.

SEE ALSO

Maplat::Web DBD::Oracle

AUTHOR

Rene Schickbauer, <rene.schickbauer@gmail.com>

COPYRIGHT AND LICENSE

Copyright (C) 2008-2011 by Rene Schickbauer

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.10.0 or, at your option, any later version of Perl 5 you may have available.