Stored Procedure - Retrieving Most Recent Order Details for a Customer

CREATE OR REPLACE PROCEDURE get_order_details_by_customer(
    IN p_customer_id INT,
    OUT order_id INT,
    OUT order_date DATE,
    OUT required_date DATE,
    OUT shipped_date DATE
)
LANGUAGE plpgsql
AS $$
BEGIN
    RAISE NOTICE 'Fetching order details for customer ID: %', p_customer_id;

    SELECT 
        o.order_id,
        o.order_date,
        o.required_date,
        o.shipped_date
    INTO 
        order_id,
        order_date,
        required_date,
        shipped_date
    FROM 
        orders o
    WHERE 
        o.customer_id = p_customer_id
    ORDER BY 
        o.order_date DESC
    LIMIT 1;
END;
$$;