--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 09:35 AM 5/06/2004 +0000, you wrote:
> >Hello,
> >
> >Below I've included a (stripped) sp. When it is executed by a TIB_DSQL
> >component the monitor shows an error:
> >
> >[ 5-6-2004 11:28:36 ]
> >CLOSE ROW CURSOR
> >STMT_HANDLE = 14707356
> >ERRCODE = 335544569
> >
> >This "dsql error" seems quit harmless, but does anybody know how to
> >get rid of it?
> >
> >
> >ALTER PROCEDURE "USER_SESSION_START2"
> >(
> > "ACCOUNTNAME" VARCHAR(32) CHARACTER SET UNICODE_FSS,
> > "USERNAME" VARCHAR(32) CHARACTER SET UNICODE_FSS,
> > "PASSWRD" VARCHAR(32) CHARACTER SET UNICODE_FSS
> >)
> >RETURNS
> >(
> > "ACCOUNTID" INTEGER
> >)
> >AS
> >BEGIN
> > ACCOUNTID = 0;
> >END
>
> It's not an IBO problem, but...
>
> If you use quoted identifiers for variables and arguments, you have

to keep

> using them, even if they are upper-case.
>
> Variables aren't like database columns where, if you define a column

with

> quotes and it's in all uppercase, with no illegal characters, you

can refer

> to it without quotes.
>
> Helen

Hi Heleen,

Sorry, I used IBAccess to export the metadata. It apparently adds
double quotes.
I don't use double quotes at all a the IB_SQL export shows:

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.