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