Adrian Witas > DBIx-Connection-0.13 > DBIx::Connection::Oracle::SQL

Download:
DBIx-Connection-0.13.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 0.06   Source  

NAME ^

DBIx::Connection::Oracle::SQL - Oracle catalog sql abstract action layer.

SYNOPSIS ^

    use DBIx::Connection::Oracle::SQL;

EXPORT ^

None

DESCRIPTION ^

    Represents sql abstract layer

ATTRIBUTES

sql

Stores definition of the following sql

 - column_info
 - schema_column_info 
 - basis_obejct_info
 - schema_obejct_info
 - unique_index_column
 - scheam_unique_index_column

METHODS

sequence_value

Returns sql statement that returns next sequence value

reset_sequence

Returns sql statement that restarts sequence.

has_sequence

Returns sql statement that check is sequence exists in database schema

table_info

Returns sql statement that check is table exists in database schema

tables_info
primary_key_info
foreign_key_info
table_foreign_key_info
column_info
unique_index_column
index_info
table_indexes_info
trigger_info
routine_info

Returns array of function info for the specified function name.

_parse_routine_argument
set_session_variables

Sets session variables. It uses the following sql command pattern,

    alter session set variable  = value;

    DBIx::Connection::Oracle::Session->initialise_session($connection, {NLS_DATE_FORMAT => 'DD.MM.YYYY'});
update_lob

Updates lob. (Large Object) Takes connection object, table name, lob column_name, lob content, hash_ref to primary key values. optionally lob size column name.

fetch_lob

Retrieves lob. Takes connection object, table name, lob column_name, hash_ref to primary key values. optionally lob size column name. By default max lob size is set to 1 GB DBIx::Connection::Oracle::SQL::LOB_MAX_SIZE = (1024 * 1024 * 1024);

_get_lob_size

Returns lob size.

SEE ALSO ^

DBIx::Connection

COPYRIGHT AND LICENSE ^

The DBIx::Connection::Oracle::SQL module is free software. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.

AUTHOR ^

Adrian Witas, adrian@webapp.strefa.pl

syntax highlighting: