#33747 [Opn->Fbk]: php5: Too many Oracle-Sessions on INSERT Statements

ID: 33747 Updated by: tony2001@php.net Reported By: alfred dot trapp at tvi-services dot de -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Linux PHP Version: 5CVS-2005-07-19 New Comment: As far as I understand it doesn't depend on the table, am I right? So why not to provide a script that CREATEs the table, INSERTs data into it and demonstrates the problem? Basically, what I want is a script that I can copy, paste, run and see the problem. That's all. Without all those variables that doesn't exist in the script, without non-existent tables etc. It's so easy, why do I need to ask you several times about it? Also, are you sure that ONLY THIS script causes the issue? If you just replace it with simple <?php oci_connect(<user>, <passwd>, <dbname>);?> - doesn't it behave in the same wrong way? It looks like another one duplicate of bug #32361, but you're talking about INSERTs for some reason. Previous Comments: ------------------------------------------------------------------------ [2005-07-20 15:05:55] alfred dot trapp at tvi-services dot de $connection=ocilogon($user, $pwd, $sid); $tablename="RESULT"; for($i=0;$i<count($result);$i++){ $queryinsert="INSERT INTO $tablename (film_id, sendungs_id, s_id , intra_anfangszeit, akt_anfangszeit, sender,titel,bew,gt,texte,bild,sparte,stnr,genre) VALUES (".$result[$i].")"; $stmt=ociparse($connection,$queryinsert); ociexecute($stmt); unset($queryinsert); } and $result is a dynamically filled array from another resource. The wanted restriction was >>not more than 20 lines of code<<. If you want to know how the result array gets filled, i have to send you the whole script. ------------------------------------------------------------------------ [2005-07-20 14:41:41] tony2001@php.net Obviously this code won't work as nobody knows where do you get $result & $tabinsert. ------------------------------------------------------------------------ [2005-07-20 14:36:54] alfred dot trapp at tvi-services dot de Hi tony Simplified Program Code $connection=ocilogon($user, $pwd, $sid); $tablename="RESULT_".$user; for($i=0;$i<count($result);$i++){ $queryinsert="INSERT INTO $tablename (".$tabinsert.") ". "VALUES (".$result[$i].")"; $stmt=ociparse($connection,$queryinsert); ociexecute($stmt); unset($queryinsert); } ocifreestatement($stmt); ocilogoff($connection); u'r welcome ------------------------------------------------------------------------ [2005-07-20 14:07:19] tony2001@php.net Please provide a clean, short and OCI8-only reproduce script. Without all those $_SESSION, fopen etc. Just a short code that contains only oci8*() calls and reproduces the problem. Thanks. ------------------------------------------------------------------------ [2005-07-19 10:20:13] alfred dot trapp at tvi-services dot de Hi sniper, thanks for the proposal, but first tests with latest win32 PHP/5.1.0-dev indicates the same bug. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/33747 -- Edit this bug report at http://bugs.php.net/?id=33747&edit=1