note 110884 added to function.oci-free-statement
| From: | passerbyxp at gmail dot com | Date: | Wed, 19 Dec 2012 08:37:50 +0000 |
| Subject: | note 110884 added to function.oci-free-statement | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-192599@lists.php.net to get a copy of this message | ||
A freed statement is not "empty()", it's still a resource:
<?php
$con=oci_connect(/*connect*/);
$q=oci_parse($con,"SELECT sysdate FROM dual");
var_dump($q); // resource(5) of type (oci8 statement)
var_dump(empty($q)); // bool(false)
var_dump(oci_statement_type($q)); // string(6) "SELECT"
echo "------\n";
oci_execute($q);
var_dump($q); // same as above
var_dump(empty($q));
var_dump(oci_statement_type($q));
echo "------\n";
oci_free_statement($q);
var_dump($q); // resource(5) of type (Unknown)
var_dump(empty($q)); // bool(false)
var_dump(oci_statement_type($q)); // generates warning and returns false
oci_close($con);
?>
So far I can not think of a way to determine if a statement is freed without using an additional
flag...
----
Server IP: 69.147.83.199
Probable Submitter: 203.98.176.247
----
Manual Page -- http://php.net/manual/en/function.oci-free-statement.php
Edit -- https://master.php.net/note/edit/110884
Del: integrated -- https://master.php.net/note/delete/110884/integrated
Del: useless -- https://master.php.net/note/delete/110884/useless
Del: bad code -- https://master.php.net/note/delete/110884/bad+code
Del: spam -- https://master.php.net/note/delete/110884/spam
Del: non-english -- https://master.php.net/note/delete/110884/non-english
Del: in docs -- https://master.php.net/note/delete/110884/in+docs
Del: other reasons-- https://master.php.net/note/delete/110884
Reject -- https://master.php.net/note/reject/110884
Search -- https://master.php.net/manage/user-notes.php