Subject | RE: [firebird-php] Re: Exexcutable Stored Procedures |
---|---|
Author | Alan McDonald |
Post date | 2005-08-05T13:40:47Z |
> --- In firebird-php@yahoogroups.com, "Ard Biesheuvel"??? can you explain this a bit more? I still can't see what your problem is.
> <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
Maybe give us the two SPs?
Alan