ID:               11468
 Updated by:       [EMAIL PROTECTED]
 Reported By:      [EMAIL PROTECTED]
 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] [EMAIL PROTECTED]

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 <[EMAIL PROTECTED]>
PS: Patch is ported from 4.0.3pl1 where is functional.

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=11468&edit=1

Reply via email to