What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.

ocifreestatement
Prev	XLIII. OCI8 Functions	Next

ocifreestatement

Name

ocifreestatement — Free all resources associated with a statement

Synopsis

int ocifreestatement(stmt); int stmt: Statement handler

Returns

TRUE on success, FALSE on error.

Description

Free all resources associated with a statement. This can be used if there a large queries being performed within a script. Normally this script is not necessaey as statement resources a freed when the current script terminates.

Version

Since versions 3.0.5 and 4.0

Example

Example 862. Free a statement identifier

if (!$db = @ocinlogon("dev","dev", "ORCL")) {
    $error = ocierror();
    printf("CONNECT error: %s", $error["message"]);
    die();
}
    $sql = "SELECT count (*) FROM phone_numbers";
    ociexecute($stmt);
    ocifetchinto($stmt, $result);
    echo "Number of rows: ".$result[0];
ocifreestatement($stmt);
ocilogoff($db);

Prev	Home	Next
ocifreedesc	Up	ociinternaldebug

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at http://www.opencontent.org/openpub/). The authors of this book have elected not to choose any options under the OPL. This online book was obtained from http://www.fooassociates.com/phpfer/ and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.