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

Returns the Oracle command for retrieving the next value from a sequence. This gets put directly into the INSERT statement.

post_fetch_id

Retrieves the value just inserted from a sequence.

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 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>