Subject | Re: [IBO] Error executing sp |
---|---|
Author | constantijnw |
Post date | 2004-06-05T10:26:56Z |
--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
I know somebody doesn't like this at all, but my answer is: I did, to
no avail.
> > > >Hi Alan,
> > > >[ 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
I know somebody doesn't like this at all, but my answer is: I did, to
no avail.