---
name: "Jifty::DBI::Handle::Oracle"
section: "3pm"
platform: "linux"
package: "libjifty-dbi-perl"
version: "0.78-3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Jifty::DBI::Handle::Oracle"
---

# Jifty::DBI::Handle::Oracle(3pm)

## NAME

```
  Jifty::DBI::Handle::Oracle - An oracle specific Handle object
```

## SYNOPSIS

## DESCRIPTION

This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.

## METHODS

### connect PARAMHASH: Driver, Database, Host, User, Password

Takes a paramhash and connects to your DBI datasource.

### database\_version

Returns value of ORA\_OCI constant, see "Constants" in DBD::Oracle.

### insert

Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

### build\_dsn PARAMHASH

Takes a bunch of parameters:

Required: Driver, Database or Host/SID, Optional: Port and RequireSSL

Builds a dsn suitable for an Oracle DBI connection

### blob\_params column\_NAME column\_type

Returns a hash ref for the bind\_param call to identify BLOB types used by the current database for a particular column type.  The current Oracle implementation only supports ORA\_CLOB types (112).

### apply\_limits STATEMENTREF ROWS\_PER\_PAGE FIRST\_ROW

takes an SQL SELECT statement and massages it to return ROWS\_PER\_PAGE starting with FIRST\_ROW;

### distinct\_query STATEMENTREF

takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

## AUTHOR

Jesse Vincent, jesse@fsck.com

## SEE ALSO

Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle