Re: [PHP4BETA] oracle problems in beta4(pl1)

On Tue, Feb 22, 2000 at 12:52:13PM +0100, Harold wrote: > we have encountered a problem with beta4 when stored procedures are executed > from php beta4(pl1).. we think it has to do with OCIBindByName.. > > when we call normal sql statements, the pages load fine.. but with stored > procedures, apache segfaults, and we get a document contains no data message > from the browser.. > > we also had this problem on a snapshot release after beta3.. > > with beta3, we do not have this problem.. > > quick snippet example: > > $contact_select_cursor = OCINewCursor($conn); > $contact_select_query = "begin sch.red_select_contact('$where_open', > '$table_order_col', '$table_order_dir', :contact_cursor); end;"; > $contact_select_action = OCIParse($conn, $contact_select_query); > OCIBindByName($contact_select_action, "contact_cursor", > &$contact_select_cursor, -1,OCI_B_CURSOR); > error_log("cornerstone1"); > OCIExecute($contact_select_action); > error_log("cornerstone2"); > OCIExecute($contact_select_cursor); > error_log("cornerstone3"); > > in error log we get: > > [error] cornerstone1 > [notice] child pid 2481 exit signal Segmentation fault (11) > > (redhat 6.1 / oracle 8.0.5(with glibcpatch) client / apache 1.3.11) > > update: we have also tried a stored procedure with bindbyname and without a > cursor.. maybe the problem lies with the cursor, and not with bindbyname.. could you please send me a tiny stored proc that returns a ref-cursor (i don't have one here, and i'm not fluent enogh in plsql to write one without looking into the docs 1st) - i'll fix that right away! BTW: if you had posted a report for the snapshot release the bug would have been fixed before b4. regards > > -- > PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > For additional commands, e-mail: php4beta-help@lists.php.net > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany