Programming Procedure

From: Delphi Dev <delphidev_at_yahoo.com>
Date: Thu, 01 Apr 1999 16:14:02 -0500
Message-ID: <3703E19A.50845BB1@yahoo.com>

I have the following in an ascii file. I then go into SQL plus and do a File Open. Then I do a run. I get an Bind variable "STATE" not declared. Is this the proper way of programing procedures into the Server?

Thanks, Stan

SET TERM !!;
CREATE PROCEDURE AVGBALANCE (STATE CHAR(22)) RETURNS (AVG_AMOUNT FLOAT)
AAS
BEGIN
SELECT AVG(BALANCE_DUE) FROM CUSTOMER WHERE STATE = :STATE INTO AVG_AMOUNT; SUSPEND;
END; !!
SET TERM; !! Received on Thu Apr 01 1999 - 15:14:02 CST