/inc/oci8_class.php

Description

Oracle Database Class.

Database Class provides a consistent API to communicate with MySQL or Oracle Databases. This one implements the OCI8 API. Requires dbdefs.inc.php for global access data (user,pw,host,appname)

  • Connect() / Disconnect()
  • Print_Error() / GetErrorText()
  • Query() / QueryResult() / FetchResult() / FreeResult()
  • Version() / GetClassVersion() / GetQueryCount()
  • Commit() / Rollback()
  • SetDebug() / PrintDebug() / SQLDebug()
  • GetBindVars() - PRIVATE!
  • DescTable()
  • Prepare() / Execute() / ExecuteHash()
  • SearchQueryCache() / RemoveFromQueryCache()
  • checkSock()
  • GetConnectionHandle() / SetConnectionHandle()
  • QueryHash() / QueryResultHash()
  • AffectedRows()
  • setErrorHandling() / getSQLError()
  • setPrefetch()
  • getOutputHash() / setOutputHash() / clearOutputHash()
  • SendEmailOnError()
  • setPConnect()
  • setConnectRetries() / getConnectRetries()

Classes
Class Description
db_oci8 OCI8 Database Class.
Constants
DBOF_CACHE_QUERY = 0 (line 74)

Used for Query Cache (V0.38+)

DBOF_CACHE_STATEMENT = 1 (line 78)

Used for Query Cache (V0.38+)

DBOF_COLNAME = 0 (line 63)

These defines are used in DescTable()

  • see: DescTable
DBOF_COLPREC = 3 (line 66)

These defines are used in DescTable()

  • see: DescTable
DBOF_COLSIZE = 2 (line 65)

These defines are used in DescTable()

  • see: DescTable
DBOF_COLTYPE = 1 (line 64)

These defines are used in DescTable()

  • see: DescTable
DBOF_DEBUGFILE = (1<<2) (line 56)

DEBUG: Debug to error_log()

DBOF_DEBUGOFF = (1<<0) (line 41)

DEBUG: No Debug Info

DBOF_DEBUGSCREEN = (1<<1) (line 49)

DEBUG: Debug on-screen

DBOF_RETURN_ALL_ERRORS = 2 (line 93)

Connect and error handling (V0.57+).

If NO_ERRORS is set and an error occures, the class still reports an an error of course but the error shown is reduced to avoid showing sensible informations in a productive environment. Set RETURN_ALL_ERRORS if you want to handle errors yourself.

DBOF_SHOW_ALL_ERRORS = 1 (line 92)

Connect and error handling (V0.57+).

If NO_ERRORS is set and an error occures, the class still reports an an error of course but the error shown is reduced to avoid showing sensible informations in a productive environment. Set RETURN_ALL_ERRORS if you want to handle errors yourself.

DBOF_SHOW_NO_ERRORS = 0 (line 91)

Connect and error handling (V0.57+).

If NO_ERRORS is set and an error occures, the class still reports an an error of course but the error shown is reduced to avoid showing sensible informations in a productive environment. Set RETURN_ALL_ERRORS if you want to handle errors yourself.

Documentation generated on Tue, 22 Sep 2009 22:17:12 +0200 by phpDocumentor 1.4.2