/ 
DBIx-SQLEngine-0.017
River stage one • 1 direct dependent • 1 total dependent
/ DBIx::SQLEngine::Driver::Oracle

NAME

DBIx::SQLEngine::Driver::Oracle - Extends SQLEngine for DBMS Idiosyncrasies

SYNOPSIS

my $sqldb = DBIx::SQLEngine->new( 'dbi:oracle:test' );

$hash_ary = $sqldb->fetch_select( 
  table => 'students' 
  limit => 5, offset => 10
);

DESCRIPTION

This package provides a subclass of DBIx::SQLEngine which compensates for Oracle's idiosyncrasies.

sql_limit

Adds support for SQL select limit clause.

do_insert_with_sequence

$sqldb->do_insert_with_sequence( $sequence_name, %sql_clauses ) : $row_count

Implemented using _seq_do_insert_preinc and seq_increment.

seq_increment

$sqldb->seq_increment( $table, $field ) : $new_value

Increments the sequence, and returns the newly allocated value.

sql_detect_any

$sqldb->sql_detect_any : %sql_select_clauses

Implemented using Oracle's "select 1 from dual".

sql_detect_table

$sqldb->sql_detect_table ( $tablename )  : %sql_select_clauses

Implemented using Oracle's "select * from $tablename limit 1".

dbms_create_column_types

$sqldb->dbms_create_column_types () : %column_type_codes

Implemented using Oracle's blob and number types.

Portability: Note that this capability is currently limited, and additional steps need to be taken to manually define sequences in Oracle.

dbms_create_column_text_long_type

$sqldb->dbms_create_column_text_long_type () : $col_type_str

Implemented using Oracle's clob type.

recoverable_query_exceptions

$sqldb->recoverable_query_exceptions() : @common_error_messages

Provides a list of error messages which represent common communication failures or other incidental errors.

SEE ALSO

See DBIx::SQLEngine for the overall interface and developer documentation.

See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.