Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Jifty::DBI::Handle::OrUser(Contributed Perl DocumJifty::DBI::Handle::Oracle(3)

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

perl v5.24.1			  2014-05-29	 Jifty::DBI::Handle::Oracle(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | AUTHOR | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Jifty::DBI::Handle::Oracle&sektion=3&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help