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.
----
Server IP: 208.69.120.35
Probable Submitter: 74.94.84.81
----
Manual Page -- http://www.php.net/manual/en/function.oci-free-statement.php
Edit -- https://master.php.net/note/edit/86092
Del: integrated -- https://master.php.net/note/delete/86092/integrated
Del: useless -- https://master.php.net/note/delete/86092/useless
Del: bad code -- https://master.php.net/note/delete/86092/bad+code
Del: spam -- https://master.php.net/note/delete/86092/spam
Del: non-english -- https://master.php.net/note/delete/86092/non-english
Del: in docs -- https://master.php.net/note/delete/86092/in+docs
Del: other reasons-- https://master.php.net/note/delete/86092
Reject -- https://master.php.net/note/reject/86092
Search -- https://master.php.net/manage/user-notes.php
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.