1Data::ObjectDriver::DriUvseerr::CDoBnDt:r:iObruDatacetldae:(P:3eOprbmlj)eDcotcDurmievnetra:t:iDorniver::DBD::Oracle(3pm)
2
3
4

NAME

6       Data::ObjectDriver::Driver::DBD::Oracle - Oracle Driver for
7       Data::ObjectDriver
8

DESCRIPTION

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

NOTES

14       Oracle doesn't support auto-increment, so before you use this feature,
15       you should create a sequence and a trigger to work with it.
16
17       For example, you want field ID in table WINES be auto-increment, then
18       create:
19
20           -- Create sequence
21           CREATE SEQUENCE WINES_ID_SEQ
22           MINVALUE 1
23           MAXVALUE 999999999999999999999999999
24           START WITH 1
25           INCREMENT BY 1
26           NOCACHE;
27
28           -- Create trigger
29           CREATE OR REPLACE TRIGGER WINES_ID_TR
30             BEFORE INSERT ON WINES
31             FOR EACH ROW
32           BEGIN
33             SELECT WINES_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
34           END;
35

LICENSE

37       This module is free software; you may redistribute and/or modify it
38       under the same terms as Perl itself.
39
41       This module is copyright (c) 2009 Xiaoou Wu <xiaoou.wu@oracle.com>.
42       All rights reserved.
43
44
45
46perl v5.30.1                      2D0a2t0a-:0:1O-b2j9ectDriver::Driver::DBD::Oracle(3pm)
Impressum