Exception Exception is a PL/SQL error that is raised during program execution. Example of Exception DECLARE v_lname VARCHAR2(15); BEGIN SELECT last_name INTO v_lname FROM employees WHERE first_name='John'; DBMS_OUTPUT.PUT_LINE ('John ''s… Continue reading "Exception in PL/SQL"
A package is a schema object that groups logically related PL/SQL types, variables, and subprograms. Packages usually have two parts: A specification (spec) A body The specification is the interface… Continue reading "PL/SQL package"
What Are PL/SQL Subprograms? A PL/SQL subprogram is a named PL/SQL block that can be called with a set of parameters. You can declare and define a subprogram within either… Continue reading "PL/SQL Subprograms"