Subject | Re: [IBO] Error executing sp |
---|---|
Author | Helen Borrie |
Post date | 2004-06-05T09:44:58Z |
At 09:35 AM 5/06/2004 +0000, you wrote:
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
>Hello,It's not an IBO problem, but...
>
>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
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