DECLARE
    v_product_id        orders.product_id%TYPE := 'your_product_id'; -- Replace with the actual product ID
    v_total_sales       NUMBER := 0;
    v_threshold         NUMBER := 10000; -- Sales threshold
BEGIN
    -- Calculate the total sales for the specific product
    SELECT SUM(quantity * price)
    INTO v_total_sales
    FROM orders
    WHERE product_id = v_product_id;

    -- Check if the total sales exceed the threshold
    IF v_total_sales > v_threshold THEN
        DBMS_OUTPUT.PUT_LINE('Product ' || v_product_id || ' is a Bestseller with total sales of ' || v_total_sales);
    ELSE
        DBMS_OUTPUT.PUT_LINE('Product ' || v_product_id || ' needs more promotion. Total sales: ' || v_total_sales);
    END IF;
EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('No sales found for product ' || v_product_id);
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('An error occurred: ' || SQLERRM);
END