[firebird-support] Problems trying to create Stored Procedure

[jim.rhema316]

Good afternoon. 

 Thank you for taking the time to help me on this.  I am new to creating and 
using Stored Procedures so please bear with me.
 

 I am trying to create this stored procedure:
 

 SET TERM #;
 CREATE PROCEDURE FindSalesAmt(Name VARCHAR(20)) RETURNS (price decimal(18,2), 
id bigint,
  description VARCHAR(90)) AS
 BEGIN 
   SELECT startprice, itemid, title from ebayrevisefile
   WHERE price > 20.00
   INTO :price, :id, :description;
   SUSPEND#
 END#
 SET TERM ;#
 GRANT EXECUTE ON PROCEDURE FindID to PUBLIC WITH GRANT OPTION;
   suspend;
 end
 

 And when I compile it I get an error on the set term.  As I understand it the 
; is a terminator so I need to use a different one within the procedure.
 

 Any help on this is appreciated.  I am using Firebird 2.5 with DBVisualizer 
Pro 9.0.3. 
 

 Thank you!