6. PL/SQL Exception Handling Basics | How -To | PL/SQL Developer Course | TechView Team | Hindi
In this video we will discuss about pl sql exception and will learn how to write to handle exception . this is 6th video of pl/sql developer course playlist, for better understanding please watch complete playlist.
----------Video Notes start from here---------------
TOO_MANY_ROWS
NO_DATA_FOUND
VALUE_ERROR
ZERO_DIVIDE
------------------------
Writing Code
------------------------
EXCEPTION
WHEN NO_DATA_FOUND
THEN
DBMS_OUTPUT.PUT_LINE('User Not Found');
WHEN TOO_MANY_ROWS
THEN
DBMS_OUTPUT.PUT_LINE('Too may User for this ID');
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM);
---------------------------------------use of exception in procedure------------
create or replace PROCEDURE HELLO_USER
(
USER_ID IN VARCHAR2
)
IS
--LOCAL VARIABLE FOR MESSAGE TEXT
LV_MESSAGE VARCHAR2(100):='WELCOME ';
LV_NAME VARCHAR2(100);
BEGIN
--TO GET NAME OF LOGGED IN USER
SELECT name INTO LV_NAME FROM CUSTOMERS
WHERE CUSTOMER_ID=USER_ID
;
DBMS_OUTPUT.PUT_LINE(LV_MESSAGE || LV_NAME);
EXCEPTION
WHEN NO_DATA_FOUND
THEN
DBMS_OUTPUT.PUT_LINE('USER ID NOT FOUND');
WHEN TOO_MANY_ROWS
THEN
DBMS_OUTPUT.PUT_LINE('TOO MANY USERS FOR THIS VALUE');
WHEN INVALID_NUMBER
THEN
DBMS_OUTPUT.PUT_LINE('ONLY NUMERIC VALUE ACCEPTABLE FOR USER ID');
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
----------------procedure ends------------------
Regards
TechView Team
Watch video 6. PL/SQL Exception Handling Basics | How -To | PL/SQL Developer Course | TechView Team | Hindi online without registration, duration hours minute second in high quality. This video was added by user TechView Team 29 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 145 once and liked it 12 people.