Example 1: Assigning a value expression to a target parameter

    BEGIN
    SET :y = (SELECT COUNT (*) FROM employees);
    END;

    Example 2: Assigning the NULL value expression to a target
    parameter

    BEGIN
    SET :z = NULL;
    END;