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