Home | Classes | Modules | Annotated | Functions | Files

OCI8Connection Class Reference

Inherits ConnectionCommon.

List of all members.

Public Member Functions

• connect ($dsninfo, $flags=0)
• close ()
• & executeQuery ($sql, $fetchmode=null)
• executeUpdate ($sql)
• commit ()
• rollback ()
• getUpdateCount ()
• applyLimit (&$sql, $offset, $limit)
• nativeError ($result=null)
• & getDatabaseInfo ()
• & getIdGenerator ()
• & prepareStatement ($sql)
• prepareCall ($sql)
• & createStatement ()

Public Attributes

• $lastStmt = null

---

Member Function Documentation

OCI8Connection::connect ( $  dsninfo,  $  flags = 0 )

Connect to a database and log in as the specified user. Parameters: array  $dsn The data source hash. int  $flags Any connection flags. public Returns mixed boolean TRUE on success, SQLException on failure. Reimplemented from Connection.

OCI8Connection::close ()

See also Connection::disconnect() Reimplemented from Connection.

& OCI8Connection::executeQuery ( $  sql,  $  fetchmode = null )

See also Connection::executeQuery() Reimplemented from Connection.

OCI8Connection::executeUpdate ( $  sql)

See also Connection::simpleUpdate() Reimplemented from Connection.

OCI8Connection::commit ()

Commit the current transaction. Returns TRUE if either successfully committed or no transactions to commit, SQLException on failure. Reimplemented from Connection.

OCI8Connection::rollback ()

Roll back (undo) the current transaction. Returns TRUE if either successfully rolled back or no transactions to rollback, SQLException on failure. Reimplemented from Connection.

OCI8Connection::getUpdateCount ()

Gets the number of rows affected by the data manipulation query. Returns int Number of rows affected by the last query. Todo: -cOCI8Connection Figure out whether getUpdateCount() should throw exception on error or just return 0. Reimplemented from Connection.

OCI8Connection::applyLimit ( &$  sql,  $  offset,  $  limit )

Build Oracle-style query with limit or offset. If the original SQL is in variable: query then the requlting SQL looks like this: SELECT B.* FROM ( SELECT A.*, rownum as TORQUE$ROWNUM FROM ( query ) A ) B WHERE B.TORQUE$ROWNUM > offset AND B.TORQUE$ROWNUM <= offset + limit Parameters: string  &$sql the query int  $offset int  $limit Returns void ($sql parameter is currently manipulated directly) Reimplemented from ConnectionCommon.

OCI8Connection::nativeError ( $  result = null)

Get the native Oracle Error Message as a string. Parameters: string  $msg The Internal Error Message mixed  $errno The Oracle Error resource

& OCI8Connection::getDatabaseInfo ()

See also Connection::getDatabaseInfo() Reimplemented from Connection.

& OCI8Connection::getIdGenerator ()

See also Connection::getIdGenerator() Reimplemented from Connection.

& OCI8Connection::prepareStatement ( $  sql)

Oracle supports native prepared statements, but the OCIParse call is actually called by the OCI8PreparedStatement class because some additional SQL processing may be necessary (e.g. to apply limit). See also OCI8PreparedStatement::executeQuery() OCI8PreparedStatement::executeUpdate() Connection::prepareStatement() Reimplemented from Connection.

OCI8Connection::prepareCall ( $  sql)

See also Connection::prepareCall() Reimplemented from Connection.

& OCI8Connection::createStatement ()

See also Connection::createStatement() Reimplemented from Connection.

---

Member Data Documentation

OCI8Connection::$lastStmt = null

---

This file is part of the Creole[php4] library.