| Subject | Problems trying to create Stored Procedure |
|---|---|
| Author | |
| Post date | 2013-11-01T16:23:13Z |
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!