|Subject||Problems trying to create Stored Procedure|
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
SELECT startprice, itemid, title from ebayrevisefile
WHERE price > 20.00
INTO :price, :id, :description;
SET TERM ;#
GRANT EXECUTE ON PROCEDURE FindID to PUBLIC WITH GRANT OPTION;
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.