GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  JIFTY::DBI::HANDLE::ORACLE (3)

.ds Aq ’

NAME



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



CONTENTS

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
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 JIFTY::DBI::HANDLE::ORACLE (3) 2014-05-29

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.