Linux Certif

Toute la documentation sur la certification Linux LPI

Data::ObjectDriver::Driver::DBD::Oracle.3pm

NAME

Data::ObjectDriver::Driver::DBD::Oracle - Oracle Driver for Data::ObjectDriver

DESCRIPTION

This module overrides methods of the Data::ObjectDriver::Driver::DBD module with Oracle specific implementation.

NOTES

Oracle doesn't support auto-increment, so before you use this feature, you should create a sequence and a trigger to work with it.

For example, you want field ID in table WINES be auto-increment, then create:

     -- Create sequence
     CREATE SEQUENCE WINES_ID_SEQ
     MINVALUE 1
     MAXVALUE 999999999999999999999999999
     START WITH 1
     INCREMENT BY 1
     NOCACHE;
 
     -- Create trigger
     CREATE OR REPLACE TRIGGER WINES_ID_TR
       BEFORE INSERT ON WINES
       FOR EACH ROW
     BEGIN
       SELECT WINES_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
     END;
 
 

LICENSE

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

AUTHOR & COPYRIGHT

This module is copyright (c) 2009 Xiaoou Wu <xiaoou.wu@oracle.com>. All rights reserved.