Hello all,

I've not used SP's much, but with my current project, I want to make almost
exclusive use of them. Anyway, I am having a bit of trouble with my current
SP. I keep getting a "Variable CUSTOMERPASS unknown". If I compile anyway,
it goes through and subsequent changes to the SP do not produce that error.
I am using IBExpert personal so I wan to see if its something with it or my
lack of understanding. Also this is the first time I've used a Dialect 3
database, but do not quote out anything in DDL statements.

Thanks,

Lee

SET TERM ^;
CREATE PROCEDURE SP_VALIDATECUSTOMER (
IP_CUSTOMERID INTEGER,
IP_CUSTOMERPASS VARCHAR(35))
RETURNS (
OP_VALIDATED INTEGER)
AS
DECLARE VARIABLE V_CUSTOMERPASS VARCHAR(35);
begin
SELECT CUSTOMERPASS /* <=== Here is offending portion */ FROM Customers
WHERE CustomerID = :IP_CustomerID
INTO v_CustomerPass;
IF (:IP_CustomerPass = :v_CustomerPass) Then
OP_Validated = 1;
Else
OP_Validated = 0;
suspend;
end
^
SET TERM ; ^