Firebird 的存储过程是否可以返回多行

Firebird存储过程是否可以返回多行？

firebird
CREATE PROCEDURE GET_ORDER_DETAILS (order_id INTEGER)
RETURNS (
    detail_id INTEGER,
    product_name VARCHAR(100),
    quantity INTEGER,
    price NUMERIC(10,2)
)
AS
BEGIN
    FOR SELECT detail_id, product_name, quantity, price
        FROM order_detail
        WHERE order_id = :order_id
        INTO :detail_id, :product_name, :quantity, :price
    DO
    BEGIN
        SUSPEND;
    END
END

firebird
SET TERM ^ ;
EXECUTE BLOCK
AS
    DECLARE detail_id INTEGER;
    DECLARE product_name VARCHAR(100);
    DECLARE quantity INTEGER;
    DECLARE price NUMERIC(10,2);
BEGIN
    FOR EXECUTE STATEMENT 'SELECT * FROM GET_ORDER_DETAILS(1)'
        INTO :detail_id, :product_name, :quantity, :price
    DO
    BEGIN
        -- 处理每一行结果
        ...
    END
END^
SET TERM ; ^