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

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

192 ratings | 17837 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 (18)
Anuj Rana (2 months ago)
Hi Manish , Why there is no need to qualify refrences to the package when using raise_application_error?
Anurag Kumar (7 months ago)
Hi Manish!! Please can you show a demo on dbms jobs and database loader
Himanshu Mittal (7 months ago)
Awsome !
aditya kumar (10 months 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 (6 months ago)
It's "RAISE" not "RIASE"
Kiran Kumar (1 year ago)
S Manish as per above program what about (SQLERRM) message ????
Raj Vizag (1 year ago)
Awesome work Manish...
Vivek (1 year ago)
Hi manish how to check table size in oracle or how to find table size in oracle ? thanks in advance
samba siva (1 month ago)
Select segment_name, segment_type, bytes/1024/1024 MB from dba_segment where segment_type='table' and segment -name ='table_name ';
Danni G (1 year ago)
Hey Manish !, me preguntaba si usted tiene algo relacionado con ODI y Oracle Database ...
Vinay NL (1 year ago)
great work manish👍...waiting 4 ua nxt video
Riyaz Basha (1 year ago)
Dear Manish... Thanks for uploading videos... your videos are good and understanding very well
VIJAY LAKSHMANNAGARI (1 year ago)
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 (1 year ago)
Thanks Manish for sharing your knowledge.waiting for PRAGMA Exception tutorial.
ashwini today (30 days 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 (1 year 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 (1 year 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.