Subject | Procedure problem |
---|---|
Author | The DeerBear |
Post date | 2002-12-21T11:27:42Z |
Hello,
Here it is my SP:
---------- STATEMENT ----------
CREATE PROCEDURE FIND_USER (
USR_NAME VARCHAR(10),
PWD VARCHAR(20))
AS
SELECT * FROM accounts WHERE "USER_NAME"=:usr_name AND "password"=:pwd
---------- ERROR MESSAGE ----------
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, char -1.
SELECT.
What's the correct way to write an SP that returns a result set?
TIA
Andrew
Here it is my SP:
---------- STATEMENT ----------
CREATE PROCEDURE FIND_USER (
USR_NAME VARCHAR(10),
PWD VARCHAR(20))
AS
SELECT * FROM accounts WHERE "USER_NAME"=:usr_name AND "password"=:pwd
---------- ERROR MESSAGE ----------
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, char -1.
SELECT.
What's the correct way to write an SP that returns a result set?
TIA
Andrew