Path

ez components / documentation / api reference / 2007.2 / database

Database: ezcDbHandlerOracle

[ Tutorial ] [ Oracle setup ] [ Class tree ] [ Element index ] [ ChangeLog ] [ Credits ]

Class: ezcDbHandlerOracle

Oracle driver implementation [source]

Parents

PDO
   |
   --ezcDbHandler
      |
      --ezcDbHandlerOracle

Inherited Member Variables

From ezcDbHandler:
protected  ezcDbHandler::$identifierQuoteChars
protected  ezcDbHandler::$transactionErrorFlag
protected  ezcDbHandler::$transactionNestingLevel

Method Summary

public ezcDbHandlerOracle __construct( $dbParams )
Constructs a handler object from the parameters $dbParams.
public ezcQueryExpressionPgsql createExpression( )
Returns a new ezcQueryExpression derived object with Oracle implementation specifics.
public ezcQuerySelectOracle createSelectQuery( )
Returns a new ezcQuerySelect derived object with Oracle implementation specifics.
public ezcUtilitiesOracle createUtilities( )
Returns a new ezcUtilities derived object with Oracle implementation specifics.
public static string getName( )
Returns 'oracle'.
protected string processLimitOffset( $queryString, $limit, $offset )
Returns an SQL query with LIMIT/OFFSET functionality appended.
public string quote( $str, [$paramStr = PDO::PARAM_STR] )
Returns $str quoted for the Oracle database.

Inherited Methods

From ezcDbHandler :
public ezcDbHandler ezcDbHandler::__construct()
Constructs a handler object.
public bool ezcDbHandler::beginTransaction()
Begins a transaction.
public bool ezcDbHandler::commit()
Commits a transaction.
public ezcQueryDelete ezcDbHandler::createDeleteQuery()
Returns a new ezcQueryDelete derived object for the correct database type.
public ezcQueryExpression ezcDbHandler::createExpression()
Returns a new ezcQueryExpression derived object for the correct database type.
public ezcQueryInsert ezcDbHandler::createInsertQuery()
Returns a new ezcQueryInsert derived object for the correct database type.
public ezcQuerySelect ezcDbHandler::createSelectQuery()
Returns a new ezcQuerySelect derived object for the correct database type.
public ezcQueryUpdate ezcDbHandler::createUpdateQuery()
Returns a new ezcQueryUpdate derived object for the correct database type.
public ezcDbUtilities ezcDbHandler::createUtilities()
Returns a new ezcUtilities derived object for the correct database type.
public string ezcDbHandler::quoteIdentifier()
Returns the quoted version of an identifier to be used in an SQL query.
public bool ezcDbHandler::rollback()
Rollback a transaction.

Methods

__construct

ezcDbHandlerOracle __construct( array $dbParams )
Constructs a handler object from the parameters $dbParams.
Supported database parameters are:
  • dbname|database: Database name
  • user|username: Database user name
  • pass|password: Database user password
  • charset: Client character set

Parameters

Name Type Description
$dbParams array Database connection parameters (key=>value pairs).

Throws

ClassDescription
ezcDbMissingParameterException if the database name was not specified.

Redefinition of

Method Description
ezcDbHandler::__construct() Constructs a handler object.

createExpression

ezcQueryExpressionPgsql createExpression( )
Returns a new ezcQueryExpression derived object with Oracle implementation specifics.

Redefinition of

Method Description
ezcDbHandler::createExpression() Returns a new ezcQueryExpression derived object for the correct database type.

createSelectQuery

ezcQuerySelectOracle createSelectQuery( )
Returns a new ezcQuerySelect derived object with Oracle implementation specifics.

Redefinition of

Method Description
ezcDbHandler::createSelectQuery() Returns a new ezcQuerySelect derived object for the correct database type.

createUtilities

ezcUtilitiesOracle createUtilities( )
Returns a new ezcUtilities derived object with Oracle implementation specifics.

Redefinition of

Method Description
ezcDbHandler::createUtilities() Returns a new ezcUtilities derived object for the correct database type.

getName

string getName( )
Returns 'oracle'.

processLimitOffset

string processLimitOffset( string $queryString, int $limit, int $offset )
Returns an SQL query with LIMIT/OFFSET functionality appended.
The LIMIT/OFFSET is added to $queryString. $limit controls the maximum number of entries in the resultset. $offset controls where in the resultset results should be returned from.

Parameters

Name Type Description
$queryString string  
$limit int  
$offset int  

quote

string quote( string $str, [int $paramStr = PDO::PARAM_STR] )
Returns $str quoted for the Oracle database.
Reimplemented from PDO since PDO is broken using Oracle8.

Parameters

Name Type Description
$str string  
$paramStr int  

Last updated: Mon, 17 Dec 2007