You can raise pre-defined exception explicitly.
SET SERVEROUTPUT ON
DECLARE
deptno NUMBER(3) := 40;
BEGIN
IF deptno NOT IN ( 10,20,30 ) THEN
RAISE INVALID_NUMBER;
END IF;
EXCEPTION
WHEN INVALID_NUMBER THEN
DBMS_OUTPUT.PUT_LINE (' Invalid Deptno supplied');
ROLLBACK;
END;
Subscribe to:
Post Comments (Atom)
External Table
Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...
-
Cursor for loop simplifies the PL/SQL program where PL/SQL itself take care most of the things which includes cursor steps and variab...
-
When an autonomous transactions is called it leaves context of calling program, perform an independent task without affecting calling prog...
-
Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...
No comments:
Post a Comment