Edit report at http://bugs.php.net/bug.php?id=30073&edit=1
ID: 30073
Comment by: george dot benjamin at gmail dot com
Reported by: almad at dracidoupe dot cz
Summary: Exception handling not work for selectable
procedures
Status: No Feedback
Type: Bug
Package: InterBase related
Operating System: Gentoo Linux
PHP Version: 5.0.1
Block user comment: N
Private report: N
New Comment:
I have the same problem, both on linux (CentOS 5.2) and on windows
(Windows7) with
interbase etension version 5.3.1.0
(php_interbase.dll/php_interbase.so).
If I use "select * from procedure_name" in ibase_query() and the
procedure raises
an exception, ibase_errmsg() and ibase_errcode() will return null
instead of the
exception message and number.
Previous Comments:
------------------------------------------------------------------------
[2009-11-13 20:42:32] tonne1 at s8zehn dot net
On Debian:
selectable SP does never return an error:
test case:
create procedure test
returns (status integer)
as
begin
status = 1 / 0;
suspend;
end;
calling
select * from test
will not raise an error.
------------------------------------------------------------------------
[2005-03-03 01:00:10] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2005-02-23 21:31:26] [email protected]
Please try using this CVS snapshot:
http://snaps.php.net/php5-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.0-win32-latest.zip
------------------------------------------------------------------------
[2004-09-13 14:31:55] almad at dracidoupe dot cz
Description:
------------
When calling executable procedure, php works good, that means that
ibase_query returns FALSE and IBase_Errmsg() contains code and text of
exception returned by stored procedure.
However, when calling selectable procedure ("select a, b from
procedure_name"), ibase_query returns TRUE and exception is returned as
unhandlingable php warning when calling ibase_fetch_row/assoc/object.
Reproduce code:
---------------
$s = ibase_query ("select var from procedure_name");
If(!$s){
echo "FireBird returned error: ".IBase_Errmsg();
}
Else{
while($d=ibase_fetch_row($s)){
echo $d[0];
}
}
Expected result:
----------------
FireBird returned error: Some exception returned by procedure_name
Actual result:
--------------
Warning: ibase_fetch_assoc() [function.ibase-fetch-assoc]: exception 1
Some exception returned by procedure_name in /var/.../script.php on line
xx
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=30073&edit=1
