Chris Winters > SPOPS > SPOPS::DBI::Oracle

Download:
SPOPS-0.87.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Module Version: 3.06   Source  

NAME ^

SPOPS::DBI::Oracle -- Oracle-specific routines for the SPOPS::DBI

SYNOPSIS ^

 # Define your table and sequence

 CREATE TABLE mytable (
   id int not null primary key,
   ...
 );

 CREATE SEQUENCE MySeq;

 # In your configuration:

 'myspops' => {
     'isa'             => [ qw/ SPOPS::DBI::Oracle SPOPS::DBI / ],
     'id'              => 'id',
     'no_insert'       => [ 'id' ],
     'increment_field' => 1,
     'sequence_name'   => 'MySeq';
     ...
 },

DESCRIPTION ^

This subclass allows you to specify a sequence name from which you can retrieve the next ID value.

METHODS ^

pre_fetch_id

Fetch the data from the specified sequence and return it.

sql_quote

DBD::Oracle uses the type of a field to implement the DBI quote() call, so we override the default 'sql_quote' from SPOPS::SQLInterface.

BUGS ^

None known.

TO DO ^

Nothing known.

SEE ALSO ^

DBD::Oracle

DBI

COPYRIGHT ^

Copyright (c) 2002-2004 intes.net, inc.. All rights reserved.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHORS ^

Chris Winters <chris@cwinters.com>

syntax highlighting: