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

go to bug id or search bugs for

Bug #67278 db2-bind-param with an INOUT Param does not work
Submitted: 2014-05-14 15:19 UTC Modified: 2015-06-05 12:27 UTC
Votes:3
Avg. Score:4.3 ± 0.9
Reproduced:0 of 0 (0.0%)
From: agitheking at gmail dot com Assigned: rahulpriyadarshi (profile)
Status: Closed Package: ibm_db2 (PECL)
PHP Version: 5.4.28 OS: RHEL 6.5
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: agitheking at gmail dot com
New email:
PHP Version: OS:

 

 [2014-05-14 15:19 UTC] agitheking at gmail dot com 
Description:
------------
---
From manual page: http://www.php.net/function.db2-bind-param
---
Problems with the db2_bin_param():

$rc=db2_bind_param($stmt, 4, "MESSAGE", DB2_PARAM_IN);print_r ($rc); works fine!
$rc=db2_bind_param($stmt, 4, "MESSAGE", DB2_PARAM_OUT);print_r ($rc);works fine!
$rc=db2_bind_param($stmt, 4, "MESSAGE", DB2_PARAM_INOUT);print_r ($rc); does not work!

the Message param is a xml.
Error Message: string '[IBM][CLI Driver][DB2] SQL0462W  Command or routine "ACCEL_CONTROL_ACCELERATOR" (specific name "ACCEL_CONTROL_ACCELERATOR") has returned a warning SQLSTATE, with diagnostic text "AQT10402I DETAILS ".  SQLSTATE=01H08'

Test script:
---------------
$sql = 'CALL SYSPROC.ACCEL_CONTROL_ACCELERATOR(?,?,?,?)';
$stmt=db2_prepare($conn, $sql);

$ACCELERATOR_NAME = $accelname;
$COMMAND = $command;
$RESULT="";

$clob = "<?xml version='1.0' encoding='UTF-8' ?>\n";
$clob .="<spctrl:messageControl xmlns:spctrl='http://www.ibm.com/xmlns/prod/dwa/2011' version='1.0' versionOnly='true'>\n";
$clob .=  "</spctrl:messageControl>";

$MESSAGE= $clob;

$rc=db2_bind_param($stmt, 1, "ACCELERATOR_NAME", DB2_PARAM_IN);print_r ($rc);
$rc=db2_bind_param($stmt, 2 ,"COMMAND"  , DB2_PARAM_IN);print_r ($rc);
$rc=db2_bind_param($stmt, 3, "RESULT", DB2_PARAM_OUT);print_r ($rc);
$rc=db2_bind_param($stmt, 4, "MESSAGE", DB2_PARAM_INOUT);print_r ($rc);

db2_execute($stmt);

Patches

patch_04Jun2014 (last revision 2014-06-04 11:30 UTC by rahulpriyadarshi@php.net)

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2014-05-15 14:16 UTC] agitheking at gmail dot com 
Also tried with:

$rc=db2_bind_param($stmt, 4, "MESSAGE", DB2_PARAM_INOUT, DB2_XML);print_r ($rc);
 [2014-05-21 14:36 UTC] agitheking at gmail dot com 
I installed the ibm_db2 PECL with the following make test Test Result:
=====================================================================
TEST RESULT SUMMARY
---------------------------------------------------------------------
Exts skipped    :    0
Exts tested     :   30
---------------------------------------------------------------------

Number of tests :  215                 2
Tests skipped   :  213 ( 99.1%) --------
Tests warned    :    0 (  0.0%) (  0.0%)
Tests failed    :    2 (  0.9%) (100.0%)
Expected fail   :    0 (  0.0%) (  0.0%)
Tests passed    :    0 (  0.0%) (  0.0%)
---------------------------------------------------------------------
Time taken      :    6 seconds
=====================================================================

=====================================================================
FAILED TEST SUMMARY
---------------------------------------------------------------------
IBM-DB2: Call a stored procedure in a different binding pattern [tests/test_148_CallSPDiffBindPattern_01.phpt]
IBM-DB2: check for connect deallocator functioning to rollback and disconnect if there is any active transaction [tests/test_connect_deallocator.phpt]
=====================================================================
 [2014-06-04 11:30 UTC] rahulpriyadarshi@php.net 
The following patch has been added/updated:

Patch Name: patch_04Jun2014
Revision:   1401881452
URL:        https://bugs.php.net/patch-display.php?bug=67278&patch=patch_04Jun2014&revision=1401881452
 [2014-06-04 11:31 UTC] rahulpriyadarshi@php.net
-Status: Open +Status: Assigned
 [2014-06-04 11:33 UTC] rahulpriyadarshi@php.net
-Assigned To: +Assigned To: rahulpriyadarshi
 [2014-06-04 11:33 UTC] rahulpriyadarshi@php.net 
Thanks for reporting this issue, I have created a patch for this and attached the patch with this issue.
 [2015-06-05 12:27 UTC] rahulpriyadarshi@php.net
-Status: Assigned +Status: Closed
 [2015-06-05 12:27 UTC] rahulpriyadarshi@php.net 
The changes are released with ibm_db2-1.9.6
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jul 02 14:01:36 2025 UTC