HomeОбразованиеRelated VideosMore From: Manish Sharma

PL/SQL tutorial 48: Declare User-Define Exception using RAISE_APPLICATION_ERROR

237 ratings | 21993 views
Manish Sharma from RebellionRider.com presents PL/SQL Tutorial on How To Declare User-Define Exception using RAISE_APPLICATION_ERROR in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/user-define-exception-2 Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (19)
Dheenavimal420 Dheena (4 months ago)
I have a doubt in this video Without exception block can we threw the error using raise application error method?
Anuj Rana (7 months ago)
Hi Manish , Why there is no need to qualify refrences to the package when using raise_application_error?
Anurag Kumar (1 year ago)
Hi Manish!! Please can you show a demo on dbms jobs and database loader
Himanshu Mittal (1 year ago)
Awsome !
aditya kumar (1 year ago)
DECLARE ex_age EXCEPTION; age NUMBER := 17; PRAGMA EXCEPTION_INIT(ex_age, -20008); BEGIN IF age<18 THEN RIASE_APPLICATION_ERROR(-20008, 'YOU should be 18 or above for drinks!'); END IF; DBMS_OUTPUT.PUT_LINE('SURE! WHAT would you like to have?'); EXCEPTION WHEN ex_age THEN DBMS_OUTPUT.PUT_LINE(SQLERRM); END; Error report - ORA-06550: line 7, column 3: PLS-00201: identifier 'RIASE_APPLICATION_ERROR' must be declared ORA-06550: line 7, column 3: PL/SQL: Statement ignored 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error. *Action: How can i handle this?
Jonathan Sanchez (1 year ago)
It's "RAISE" not "RIASE"
Kiran Kumar (2 years ago)
S Manish as per above program what about (SQLERRM) message ????
Raj Vizag (2 years ago)
Awesome work Manish...
Vivek (2 years ago)
Hi manish how to check table size in oracle or how to find table size in oracle ? thanks in advance
samba siva (6 months ago)
Select segment_name, segment_type, bytes/1024/1024 MB from dba_segment where segment_type='table' and segment -name ='table_name ';
Danni G (2 years ago)
Hey Manish !, me preguntaba si usted tiene algo relacionado con ODI y Oracle Database ...
Vinay NL (2 years ago)
great work manish👍...waiting 4 ua nxt video
Riyaz Basha (2 years ago)
Dear Manish... Thanks for uploading videos... your videos are good and understanding very well
Thanks lot manish your videos very use full so many people like me, i am looking for preparing Oracle certification(OCA), can you please guide me how to crack certification exam. Best Regards, Vijay Lakshmannagri.
Ramesh G (2 years ago)
Thanks Manish for sharing your knowledge.waiting for PRAGMA Exception tutorial.
ashwini today (6 months ago)
Fantastic video.. will be waiting for Performance Tunning series😊
Pradyumna Janga (1 year ago)
Why do we need OTHERS case in this situation? There are only 2 options right? Above 18 or under 18. Can you do a video showing the case where we use the third block (SQLERRM)?
Manish Sharma (2 years ago)
Your welcome. I am glad that you enjoyed the tutorial. Stay tuned I will be bringing the next video soon. Do subscribe.
Puk Ka (2 years ago)
Manish, your videos are amazing. My only request is can you upload a video on Regular expression and Xpath for PL/SQL ? Thanks

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.