Subject Re: [IBO] Error executing sp
Author constantijnw
--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> > > >
> > > >[ 5-6-2004 11:28:36 ]
> > > >CLOSE ROW CURSOR
> > > >STMT_HANDLE = 14707356
> > > >ERRCODE = 335544569
> > > >
> This is similar to cursor unknown
>
> > CREATE PROCEDURE USER_SESSION_START2 (
> > ACCOUNTNAME VARCHAR(32),
> > USERNAME VARCHAR(32),
> > PASSWRD VARCHAR(32) )
> > RETURNS (
> > ACCOUNTID INTEGER )
> > AS
> > BEGIN
> > ACCOUNTID = 0;
> > END^
> >
> > I've executed the sp in IB_SQL's DSQL tab and the same error comes up.
> >
>
> Have you tried using SUSPEND; after the assignment?
> Alan

Hi Alan,

I know somebody doesn't like this at all, but my answer is: I did, to
no avail.