Hello,

Look at this:

---------- STATEMENT ----------

CREATE PROCEDURE NEW_PROCEDURE (
USR_NAME VARCHAR(10),
"Pwd" VARCHAR(20))
AS
begin
/* Procedure Text */
SELECT * FROM ACCOUNTS WHERE "USER_NAME"=:USR_NAME AND "PASSWORD"=:Pwd
end

---------- ERROR MESSAGE ----------

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 8, char -1.
end.

What is the prob with this SP?

Should I define out params as well?
How do I return a result-set?

TIA

Andrew


[Non-text portions of this message have been removed]