PL/SQL tutorial 47: How to declare user-define exception using a EXCEPTION variable

------------------------------------------------------------------------
►►►LINKS◄◄◄
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

___Facebook Official Page___

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

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[vinaynl]

hi manish..gr8 work buddy..i got interest in pl/sql oly bcoz of u n ur way of xplaining t things wit simple examples👍waiting 4 ur upcoming videos

[nabinghosh]

thank u very much manish make such videos continuously....

[nabinghosh]

GREAT CONTENT with great lecture....


😋😋😋😋😋

[kiranavula]

hi Manish Thanks for sharing your Valuable knowledge. i am looking forward for your next videos may i know when they will get uploaded?? thanks!! and happy new year :-)

[eshwerm]

HI Manish ji Could you plz
send the exception handle code in the blog plz thus we can learn better way.🤝🤝🙏🙏🧜‍♂

[NPC_YOUTUBE_USER]

do you have video for hndling pre-defined exceptions?

[pmtechcentrepmtc]

Great content Sir
But
I need
In which book u referred this topics Sir

[vishalsaxena]

exception blok k bad hm apna code phr se run krna chahte h wo kse hoga

[vijaylakshmannagari]

Hi Manish, i am planing to prepare oracle certifcation(OCA).can you please give me your mail id for more details about certification purpose.

[pratikghosh]

declare
unit_price integer;
ex_div exception;
begin
for i in(select * from sales_order)loop
if i.quantity=0 then
raise ex_div;
end if;
unit_price:= i.amount/i.quantity;
'||i.order_date||' '||i.item_name||' '||i.amount||' '||i.quantity||' '||unit_price);

exception
when ex_div then
dbms_output.put_line('error error');

end loop;
end;

i am getting error like:
ORA-06550: line 12, column 1:
PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following:

( begin case declare end exit for goto if loop mod null
pragma raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
json_exists json_value json_query json_object json_


could u plzz help me out with this