Subject Re: [firebird-php] SPs Docs
Author Milan Babuskov
Nigel Weeks wrote:
>>It just can't be done (at least in current FB versions). You
>>need either
>>selectable stored procedure or a select to return *anything*.
>>Selectable
>>SP is out of the question. To insert records you need DML-SP which
>>cannot be selected from or joined with a table, so you can't go with
>>select either.
>
> Does anyone know if you can execute an 'Execute procedure' from PHP?

Sure.

ibase_query("execute procedure some_nonselectable_sp(params)");

If it is selectable do:

ibase_query("select * from some_selectable_sp(params)");

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org