|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #81586 PDO OCI binds boolean false as NULL
Submitted: 2021-11-02 17:50 UTC Modified: -
Avg. Score:5.0 ± 0.0
Reproduced:3 of 3 (100.0%)
Same Version:2 (66.7%)
Same OS:1 (33.3%)
From: morozov at tut dot by Assigned:
Status: Open Package: PDO OCI
PHP Version: 8.0.12 OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: morozov at tut dot by
New email:
PHP Version: OS:


 [2021-11-02 17:50 UTC] morozov at tut dot by
It looks like the extension doesn't implement any special handling of the PDO::PARAM_BOOL binding type which makes the logic of binding boolean values inconsistent with the rest of the PDO extensions.

Test script:
$conn = new PDO('oci:dbname=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=XE)))', 'system', 'oracle');
$stmt = $conn->prepare('SELECT ?, ? FROM DUAL');
$stmt->bindValue(1, true, PDO::PARAM_BOOL);
$stmt->bindValue(2, false, PDO::PARAM_BOOL);

Expected result:
array(2) {
  [0] =>
  string(1) "1"
  [1] =>
  string(1) "0"

Actual result:
array(2) {
  [0] =>
  string(1) "1"
  [1] =>


Add a Patch

Pull Requests

Add a Pull Request

PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Fri Aug 19 23:05:44 2022 UTC