Oracle tutorial : User Defined Exception in Oracle PL SQL
Oracle tutorial: User Defined Exception in Oracle PL SQL
pl sql exception handling
pl sql exception handling examples
This video will show you how to raise user defined exceptions in oracle.
Example:
BEGIN
IF condition THEN
RAISE exception_name;
END IF;
EXCEPTION
WHEN exception_name THEN
statement;
END;
1)We can defined exception to make your own exception.
2)This exception must be declare yourself and RAISE statement to raise explicitly.
Declare exception : user_define_exception_name EXCEPTION;
RAISE exception : RAISE user_define_exception_name;
How to use :
WHEN user_define_exception_name THEN
//User Action
lets see an example
DECLARE
exception1 EXCEPTION;
g NUMBER;
BEGIN
FOR g IN (SELECT * FROM EMPLOYEE) LOOP
IF g.ID = 7 THEN
RAISE exception1;
END IF;
END LOOP;
EXCEPTION
WHEN exception1 THEN
dbms_output.put_line(‘WE HAVE FOUND EMPLOYEE NUMBER 7’);
END;
/
Subscribe on youtube:
/ @techquerypond
For more tutorial please visit #techquerypond
https://techquerypond.com
https://techquerypond.wordpress.com
/ techquerypond
On this page of the site you can watch the video online Oracle tutorial : User Defined Exception in Oracle PL SQL with a duration of hours minute second in good quality, which was uploaded by the user Tech Query Pond 18 February 2016, share the link with friends and acquaintances, this video has already been watched 430 times on youtube and it was liked by 14 viewers. Enjoy your viewing!
