GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  CLASS::DBI::ORACLE (3)

.ds Aq ’

NAME

Class::DBI::Oracle - Extensions to Class::DBI for Oracle

CONTENTS

SYNOPSIS



  package Music::DBI;
  use base Class::DBI::Oracle;
  Music::DBI->set_db(Main, dbi:Oracle:tnsname, username, password);

  package Artist;
  use base Music::DBI;
  __PACKAGE__->set_up_table(Artist);
 
  # ... see the Class::DBI documentation for details on Class::DBI usage



DESCRIPTION

This is an extension to Class::DBI that currently implements:



        * A sequence fix for Oracle databases.
       
        * Automatic column name discovery.
       
        * Automatic primary key detection.

        * Sequence name guessing.

        * Proper aliasing of reserved words.



Instead of setting Class::DBI as your base class, use this.

BUGS

The sequence guessing is just that. If your naming convention follows the defacto standard of TABLENAME_SEQ, and you only use one sequence per table, this will work.

The primary and column name detection lowercases all names found. This is probably what you want. If it’s not, don’t use set_up_table.

AUTHOR

Teodor Zlatanov

Dan Sully <daniel-cpan@electricrain.com> added initial column, primary key and sequence finding.

Jay Strauss <classdbi@heyjay.com> updated column, primary key, and sequence finding. Added aliasing reserved words

SEE ALSO

Class::DBI Class::DBI::mysql Class::DBI::Pg
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 CLASS::DBI::ORACLE (3) 2003-07-16

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.