Subject | Re: Exexcutable Stored Procedures |
---|---|
Author | yahdominiek |
Post date | 2005-08-05T13:00:16Z |
--- In firebird-php@yahoogroups.com, "Ard Biesheuvel"
<ard.biesheuvel@p...> wrote:
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
<ard.biesheuvel@p...> wrote:
> > My question : is there no way to use an *executable* storedprocedure
> > as it is intended ?Yes, but there seems to be no way of retrieving the 'RETURNING_VALUES'
>
> ibase_query() in PHP 5+ allows 'EXECUTE PROCEDURE ...' statements to
> be executed, so I don't really see what the problem is.
>
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