note 86092 added to function.oci-free-statement

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