Class: OCI8PreparedStatement

Source Location: /creole/drivers/oracle/OCI8PreparedStatement.php

Class Overview

PreparedStatementCommon
   |
   --OCI8PreparedStatement

Oracle (OCI8) implementation of PreparedStatement.

Author(s):

David Giffin <david@giffin.org>
Hans Lellelid <hans@xmpl.org>

Version:

$Revision: 1.14 $

Methods

Inherited Variables

Class: PreparedStatementCommon

PreparedStatementCommon::$boundInVars
PreparedStatementCommon::$conn
PreparedStatementCommon::$limit
PreparedStatementCommon::$offset
PreparedStatementCommon::$positions
PreparedStatementCommon::$positionsCount
PreparedStatementCommon::$resultSet
PreparedStatementCommon::$sql
PreparedStatementCommon::$updateCount

Inherited Methods

Class: PreparedStatementCommon

PreparedStatementCommon::__construct()

Create new prepared statement instance.

PreparedStatementCommon::close()

Nothing to close for emulated prepared statements.

PreparedStatementCommon::escape()

Escapes special characters (usu. quotes) using native driver function.

PreparedStatementCommon::executeQuery()

Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.

PreparedStatementCommon::executeUpdate()

Executes the SQL INSERT, UPDATE, or DELETE statement in this PreparedStatement object.

PreparedStatementCommon::getConnection()

PreparedStatementCommon::getLimit()

PreparedStatementCommon::getMoreResults()

PreparedStatementCommon::getOffset()

PreparedStatementCommon::getResource()

Statement resources do not exist for emulated prepared statements, so this just returns

null

PreparedStatementCommon::getResultSet()

PreparedStatementCommon::getUpdateCount()

PreparedStatementCommon::replaceParams()

Replaces placeholders with the specified parameter values in the SQL.

PreparedStatementCommon::set()

A generic set method.

PreparedStatementCommon::setArray()

Sets an array.

PreparedStatementCommon::setBlob()

PreparedStatementCommon::setBoolean()

Sets a boolean value.

PreparedStatementCommon::setClob()

PreparedStatementCommon::setDate()

PreparedStatementCommon::setDecimal()

PreparedStatementCommon::setDouble()

PreparedStatementCommon::setFloat()

PreparedStatementCommon::setInt()

PreparedStatementCommon::setInteger()

Alias for setInt()

PreparedStatementCommon::setLimit()

PreparedStatementCommon::setNull()

PreparedStatementCommon::setOffset()

PreparedStatementCommon::setString()

PreparedStatementCommon::setTime()

PreparedStatementCommon::setTimestamp()

Class Details

[line 33]
Oracle (OCI8) implementation of PreparedStatement.

Tags:

version:	$Revision: 1.14 $
author:	David Giffin <david@giffin.org>
author:	Hans Lellelid <hans@xmpl.org>

[ Top ]

Class Methods

method close [line 55]

void close(
)

Because MySQL doesn't support prepared statements, this does nothing.

Tags:

see:

PreparedStatement::close()

Overrides PreparedStatementCommon::close() (Nothing to close for emulated prepared statements.)

[ Top ]

method escape [line 65]

string escape(
string
$str)

' -> ''

Tags:

access:

protected

Overrides PreparedStatementCommon::escape() (Escapes special characters (usu. quotes) using native driver function.)

Parameters:

string

$str

[ Top ]

method executeQuery [line 77]

ResultSet executeQuery(
[mixed
$p1 = null], [int
$fetchmode = null])

Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.

Tags:

access:	public
throws:	SQLException if a database access error occurs.

Overrides PreparedStatementCommon::executeQuery() (Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.)

Parameters:

mixed	$p1	Either (array) Parameters that will be set using PreparedStatement::set() before query is executed or (int) fetchmode.
int	$fetchmode	The mode to use when fetching the results (e.g. ResultSet::FETCHMODE_NUM, ResultSet::FETCHMODE_ASSOC).

[ Top ]

method executeUpdate [line 126]

int executeUpdate(
[array
$params = null])

Executes the SQL INSERT, UPDATE, or DELETE statement in this PreparedStatement object.

Tags:

return:	Number of affected rows (or 0 for drivers that return nothing).
access:	public
throws:	SQLException if a database access error occurs.

Overrides PreparedStatementCommon::executeUpdate() (Executes the SQL INSERT, UPDATE, or DELETE statement in this PreparedStatement object.)

Parameters:

array

$params

Parameters that will be set using PreparedStatement::set() before query is executed.

[ Top ]

method setBlob [line 237]

void setBlob(
string
$paramIndex, mixed
$blob)

Overrides PreparedStatementCommon::setBlob() (parent method not documented)

Parameters:

string	$paramIndex
mixed	$blob	Blob object or string containing data.

[ Top ]

method setClob [line 254]

void setClob(
string
$paramIndex, mixed
$clob)

Overrides PreparedStatementCommon::setClob() (parent method not documented)

Parameters:

string	$paramIndex
mixed	$clob	Clob object or string containing data.

[ Top ]

Documentation generated on Mon, 23 Aug 2004 21:52:06 -0400 by phpDocumentor 1.3.0RC3