#37706 [Opn->Csd]: oci8 maps to same descriptor when fetching multiple rows with lobs

ID: 37706 Updated by: tony2001@php.net Reported By: crescentfreshpot at yahoo dot com -Status: Open +Status: Closed Bug Type: Documentation problem Operating System: Win XP PHP Version: 5CVS-2006-06-05 (snap) Previous Comments: ------------------------------------------------------------------------ [2006-06-06 12:48:45] tony2001@php.net Sure. Feel free to send a patch for the docs. ------------------------------------------------------------------------ [2006-06-06 12:45:11] crescentfreshpot at yahoo dot com Well it was not obvious that all my fetched rows would all point to the same (last fetched) lob descriptor in underlying memory, so can we say this at least needs to be documented? ------------------------------------------------------------------------ [2006-06-06 06:36:54] tony2001@php.net I don't see any way to bind several variables to one placeholder/column in OCI API, so we reuse the same descriptor on each iteration. ------------------------------------------------------------------------ [2006-06-06 00:29:57] crescentfreshpot at yahoo dot com Three things: a) AFAIK php has no problems with having multiple stream handles open, so does your "it's expected" comment refer to limitations in the oci library itself? b) is this why there is no way to stop oci_fetch_all from automatically fetching my lob data and instead return them to me as separate, *individual* streams? b) Is there no workaround for this? Something along the lines of php_stream_copy_to_stream to save a reference to an oci stream as it's fetched say in a fetchAll scenario? ------------------------------------------------------------------------ [2006-06-05 22:21:38] tony2001@php.net $row1[0] and $row2[0] are different variables pointing to the same LOB descriptor. This is how it works and it's expected. ------------------------------------------------------------------------ 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/37706 -- Edit this bug report at http://bugs.php.net/?id=37706&edit=1