---
name: "Data::ObjectDriver::Driver::DBD::Oracle"
section: "3pm"
platform: "linux"
package: "libdata-objectdriver-perl"
version: "0.25-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Data::ObjectDriver::Driver::DBD::Oracle"
---

# Data::ObjectDriver::Driver::DBD::Oracle(3pm)

Oracle Driver for Data::ObjectDriver

## 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.