--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:

> > > it must have something to do with this component:
> > > This component is used for all InterBase DSQL statements that do not
> > involve
> > > the handling of multiple rows of output data.
> > > But yours is giving back a row of data..
> > > Have you tried the same thing with a IB_Cursor?
> > > Alan
> >
> > Yes, but it returned nothing, for obvious reasons I guess.
> >
> >
>
> Do you mean it retrned no error or no return value? The cursor

should return

> the value but you now need to use the SELECT syntax
> SELECT ACCOUNTID FROM

USER_SESSION_START2(:ACCOUNTNAME,:USERNAME:PASSWRD);

>
> Alan

No value. Nevertheless, I must be able to run this executable sp with
TIB_DSQL, right?

I've tried to pin down the problem further:

CREATE PROCEDURE SP_3
RETURNS (
ACCOUNTID INTEGER )
AS
BEGIN
ACCOUNTID = 1;
END^

and

CREATE PROCEDURE SP_4 (
ACCOUNTNAME VARCHAR(32) )
AS
BEGIN

END^

Only SP_3 invoked the error (excuting from the IB_SQL DSQL tab). The
returnvalue is as expected: 1.