> 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?
First of all you need a ';' after a statement and ...
>
> Should I define out params as well?
> How do I return a result-set?
>
... and secondly this procedure will do nothing at all.