Can you have a BEGIN and END block within another BEGIN and END block?
What is the difference between a package specification and a package body?
What's wrong with this code?
CREATE PACKAGE emp_calc AS
PROCEDURE calc_bonus(emp_id NUMBER);
CREATE PACKAGE BODY emp_calc AS
PROCEDURE calculate_bonus(emp_id NUMBER) AS
SET bonus = salary * 0.1
WHERE id = emp_id;
What happens if an error is found in a nested block, and it is handled by the EXCEPTION section and is passed to a DBMS_OUTPUT.PUT_LINE function?