debian man page for data::objectdriver::driver::dbd::oracle

Data::ObjectDriver::Driver::DBD::Oracle(3pm)		User Contributed Perl Documentation	      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.

perl v5.12.4							    2011-08-29			      Data::ObjectDriver::Driver::DBD::Oracle(3pm)