Subject Re: Exexcutable Stored Procedures
Author yahdominiek
--- In firebird-php@yahoogroups.com, "Ard Biesheuvel"
<ard.biesheuvel@p...> wrote:
> > My question : is there no way to use an *executable* stored
procedure
> > as it is intended ?
>
> ibase_query() in PHP 5+ allows 'EXECUTE PROCEDURE ...' statements to
> be executed, so I don't really see what the problem is.
>
Yes, but there seems to be no way of retrieving the 'RETURNING_VALUES'
without the use of 'suspend' and thus turning it into a selectable
stored procedure which is then unusable in DBExpress for instance.

I find it very tedious to have an executable stored procedure
for 'normal' use and a selectable one which simply wraps the executable.

I know it's not part of DSQL but it would be very nice to be able to
use the same SP in each and every approach to Firebird.

just my 2 cents...

Dominiek D'hondt