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

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

perl v5.40.1                                       2025-04-19              Data::ObjectDr...er::DBD::Oracle(3pm)

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

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

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

       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;