> > > 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
> >
> > ??? can you explain this a bit more? I still can't see what your
> problem is.
> > Maybe give us the two SPs?
> > Alan
>
> Sorry for being unclear
> it must be Friday :)
>
> the executable SP :
>
> SET TERM ^^ ;
> CREATE PROCEDURE P_X_GETTEKST (
> ITEM Integer,
> LNG SmallInt,
> CMP SmallInt)
> returns (
> TXT VarChar(1024))
> AS
> begin
> SELECT A.TEKST
> FROM TRANSLATIONS A
> WHERE ((A.TEXT_ID = :item) AND (A.LANGUAGE_ID = :lng))
> INTO :txt;
>
> IF (txt IS NULL) THEN BEGIN
> SELECT A.TEKST
> FROM TRANSLATIONS A
> WHERE ((A.TEXT_ID = :item) AND
> (A.LANGUAGE_ID = (SELECT B.DEFLANG
> FROM COMPANY_PARAMS B
> WHERE COMPANY_ID = :cmp)))
> INTO :txt;
>
> END
> end
> ^^
> SET TERM ; ^^
>
> Remark : no 'SUSPEND';
> Output is through the return parameter.
>
> In Delphi, DBExpress has a component TSQLStoredProcedure which I can
> use like this :
> //// the component is connected to the SP and :
> ////
> SPGetTekst.ParamByName('ITEM').AsInteger := FiItem;
> SPGetTekst.ParamByName('LNG').AsSmallInt := FiLang;
> SPGetTekst.ParamByName('CMP').AsSmallint := FiComp;
> SPGetTekst.ExecProc;
> sTekst := SPGetTekst.ParamByName('TXT').AsString;
> ////
> just setting of input parameters, executing and reading of
> outputparameter(s).
> no need for TSQLQuery...
>
> I have found no way of doing this in PHP/FB except for making a
> wrapper SELECTABLE SP :
>
> SET TERM ^^ ;
> CREATE PROCEDURE P_C_GETTEKST (
> ITEM Integer,
> LNG SmallInt,
> CMP SmallInt)
> returns (
> TXT VarChar(1024))
> AS
> begin
> EXECUTE PROCEDURE P_X_GETTEKST (:item, :lng, :cmp)
> RETURNING_VALUES (:txt);
> suspend;
> end
> ^^
> SET TERM ; ^^
>
> This I use like this:
>
> function fb_gettekst($item, $lng, $cmp)
> {
> $fbconn = fb_connect();
> $stmt = "SELECT * FROM P_C_GETTEKST ( ? , ?, ? )";
> $fbqry = ibase_prepare($fbconn, $stmt);
> $res = ibase_execute($fbqry, $item, $lng, $cmp);
> $result = ibase_fetch_row($res);
> ibase_free_query($fbqry);
> ibase_close($fbconn);
>
> return htmlentities($result[0]);
> }
>
> It's the need for the wrapper-SP that bothers me. I have to make this
> for all existing executable SP's while I'd wish to use them as they are.
> I hope I make sense this time :)
>
> Dominiek D'hondt
>

and you are saying that you cannot use SELECT TXT FROM P_X_GETTEKST syntax
in PHP?
Alan