Data::ObjectDriver::DrUser:ContributData::ObjectDriver::Driver::DBD::Oracle(3)NAMEData::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.
perl v5.14.120Data::ObjectDriver::Driver::DBD::Oracle(3)