SPOPS::DBI::Oracle -- Oracle-specific routines for the SPOPS::DBI
# 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'; ... },
This subclass allows you to specify a sequence name from which you can retrieve the next ID value.
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.
quote()
None known.
Nothing known.
DBD::Oracle
DBI
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.
Chris Winters <chris@cwinters.com>
To install SPOPS, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SPOPS
CPAN shell
perl -MCPAN -e shell install SPOPS
For more information on module installation, please visit the detailed CPAN module installation guide.