oci_free_statement

(PHP 5, PECL oci8 >= 1.1.0)

oci_free_statement — 文やカーソルに関連付けられた全てのリソースを解放する

説明

bool oci_free_statement ( resource $statement )

oci_parse() の結果や Oracle から取得した、 Oracle のカーソルおよび文に関連付けられた全てのリソースを解放します。

パラメータ

statement: 有効な OCI ステートメント ID。

返り値

成功した場合に TRUE を、失敗した場合に FALSE を返します。

add a note User Contributed Notes
oci_free_statement

Jen M.
02-Oct-2008 06:05


oci_free_statement doesn't always free up cursors.  I had a query where I performed the following functions in a loop:



OCIParse

OCIExecute

Oci_fetch_assoc

(Grab some field values)

OciFreeStatement



I didn't specify the use of a cursor, but ran into a "maximum 

open cursors exceeded" error.  Within my code, I had one "select * from table_with_lobs" query.  When I changed the query to be "select a, b, c, from table_with_lobs" (where I specified the actual column names and where those columns were not LOB fields) the error message went away and I didn't have to resort to upping the max_open_cursors value in Oracle.

rada at instinctive dot it
04-Mar-2008 04:46


If you are using cursors, make sure to free the statement *and* the cursor, especially if there is a possibility of running the proc/cursor again (e.g. with different parameters). 



<?php



    oci_execute($stmt);

    oci_execute($crsr);



    // iterate through cursor...

    

    oci_free_statement($stmt);

    oci_free_statement($crsr);

?>



You need to do it explicitly, closing connection for example does not seem to release the cursor.

add a note

oci_internal_debug

oci_field_type

Last updated: Fri, 06 Nov 2009