Bug #11468 Updated: Cannot execute stored procedures

ID: 11468 Updated by: Vladimir.Michl@seznam.cz Reported By: Vladimir.Michl@seznam.cz Status: Open Bug Type: InterBase related Operating System: Win32, Linux PHP Version: 4.0.5 New Comment: Stored procedures may be executed, but if stored procedure return some data, I don't want how to get it. Yes some way is by select SQL command and SUSPEND in procedure, but it is not ideal way. May someone tell me how do it? Previous Comments: ------------------------------------------------------------------------ [2001-06-13 12:25:03] Vladimir.Michl@seznam.cz Hello, when I wrote some scripts that inserting some data to database, I must call stored procedures for getting some data (typically id from generator). I want execute stored procedures, that return next row id. I add some code to interbase PHP module, that support execution of stored procedures. With my patch, procedure is executed by $res = ibase_query($db, "execute procedure procedure_name"); $row = ibase_fetch_row($res); In $row is row returned by procedure. Patch may be found on http://www.penguin.cz/~michlv/software/phpibase/ If any question write me. Vladimir Michl <Vladimir.Michl@seznam.cz> PS: Patch is ported from 4.0.3pl1 where is functional. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=11468&edit=1