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>