php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #57563 Preparing procedure and executing segfaults
Submitted: 2007-03-07 08:07 UTC Modified: 2007-05-07 19:10 UTC
From: vlads at krediidiinfo dot ee Assigned:
Status: Not a bug Package: PDO_INFORMIX (PECL)
PHP Version: 5.2.1 OS: SUSE Linux 9
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: vlads at krediidiinfo dot ee
New email:
PHP Version: OS:

 

 [2007-03-07 08:07 UTC] vlads at krediidiinfo dot ee 
Description:
------------
Preparing procedure and executing it as shown in the manual results in segmentation fault.

Reproduce code:
---------------
$ifx = new PDO('informix:host=db.kisise;service=1526;database=krediit;server=db_krediit;protocol=onsoctcp; EnableScrollableCursors=0','someuse','somepass');
$tmp->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$tmp->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_TO_STRING);

try
{
  $ret = '';
  $stmt = $ifx->prepare('execute procedure proc_esmakanne(today-1,today)');
  $stmt->bindParam(1, $ret, PDO::PARAM_STR, 4000); 
  $stmt->execute();
}
catch (Exception $dbe) {}


Expected result:
----------------
Variable $ret has some value

Actual result:
--------------
segfault

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-03-23 11:59 UTC] tom at advancedatatools dot com 
If you have not tried to do so already, upgrade to 1.1.0, that fixed a number of the bugs I was having with bindParam.
 [2007-03-23 12:07 UTC] kfbombar at us dot ibm dot com 
Does the upgrade resolve this issue and/or issue 10281?  Please let us know.
 [2007-03-23 12:11 UTC] vlads at krediidiinfo dot ee 
This is a bug report for 1.1.0, the same applies to 10281.
 [2007-05-07 19:10 UTC] opendev at us dot ibm dot com 
The script provided will need to be tweaked a bit for it to work correctly.  The primary problem is in the attempt to prepare and execute a "EXECUTE PROCEDURE".  This can only be done by direct execution.  So a slight modification on your script will fix this.  For example:

$query = 'EXECUTE PROCEDURE proc_esmakanne(today-1, today)';
$stmt = $conn->query($query);
$res = $stmt->fetch();
var_dump($res);

This will provide your needed output.  We hope this clarifies the issue.  Thank you.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sun Jan 05 04:01:29 2025 UTC