I connected to firebird db from php pdo:
<?php
const _QUERY = 'SELECT * FROM R_GETTABLEPROPS(:ATABLEID,:ATABLENAME,:AMASTERTABLEID,:AMASTERTABLENAME,:FLAGS)';
$dbh = new PDO($dsn, $dbconf['user'], $dbconf['pass']);
$s = $dbh->prepare(_QUERY);
$s->bindValue(':ATABLENAME', 'LISTW');
$s->execute(); // error here
$s->bindColumn('SQLCOMMAND', $data, PDO::PARAM_LOB);
$query = $s->fetchAll(PDO::FETCH_BOUND);
R_GETTABLEPROPS is:
create or alter procedure R_GETTABLEPROPS (
ATABLEID integer,
ATABLENAME varchar(31),
AMASTERTABLEID integer,
AMASTERTABLENAME varchar(31),
FLAGS varchar(10))
returns (
TABLEID integer,
SQLCOMMAND blob sub_type 1 segment size 80
as …
Error:
PDOException: SQLSTATE[HY000]: General error: -804 Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA structure
How working with FB blobs in PDO? Queries without blobs is working!
FB client and server is version 2.1.2.