Transactions Yes Locking Yes, implicit and explicit Table joins Yes, inner and outer LONG/LOB datatypes Yes, up to 4 GB Statement handle attributes available After prepare( ) Placeholders Yes, "?" and ":1" styles (native) Stored procedures Yes Bind output values Yes Table name letter case Insensitive, stored as uppercase Field name letter case Insensitive, stored as uppercase Quoting of otherwise invalid names Yes, via double quotes Case-insensitive "LIKE" operator No Server table ROW ID pseudocolumn Yes, "ROWID" Positioned update/delete No Concurrent use of multiple handles Unrestricted
Author and contact details
The driver author is Tim Bunce. He can be contacted via the dbi-users mailing list.
Supported database versions and options
DBD::Oracle module supports both Oracle 7 and
Building for Oracle 8 defaults to use the new Oracle 8 OCI interface,
which enables use of some Oracle 8 features including LOBs and
An emulation module for the old Perl4 oraperl software is supplied
DBD::Oracle, making it very easy to upgrade
oraperl scripts to Perl5.
For further information about Oracle, refer to:
Differences from the DBI specification
DBD::Oracle has no known significant differences
in behavior from the current DBI specification.
Data Source Name, or DSN, can be one ...