Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Programming Procedure
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