Oracle PL SQL interview question What is raise application error

Oracle PL SQL interview question What is raise application error

[chsurekha]

I got clear picture on exceptions, till not i m very much confused as my complete journey from starting of my career, i was involved only into support project. Never got chance to write code, we will always miss clarity on small points. Now with this series on exception it ruled out all my confusion. thq so much

[lekhyadivya]

Very informative a d easy to understand... Nice sir

[randomcreator]

please make videos on performance tuning in Oracle. and thanks for the awesome and helpful videos.

[ghoshjayanta]

Hi Siva sir, like other exceptions(user defined/system defined exceptions) this would move the control to the exception handling section. But this raise_application_error does not need any exception handling section to be defined. It would just stop execution and return to caller program? Is my understanding is correct?

[ldk]

@SivaAcademy not getting last point in the video where raise application error throwback to calling proc .. please explain

[gouthamipasham]

how are we handling an exception after raising it using raise_application_error ? is it just by using when others clause in the calling procedure exception block?

[mdnizamraza]

What is the use of third parameter in raise_application_error()? Plz explain it with an example.

[adeokatepatil]

Hi sir, your videos are very powerful as knowledge perspective, thanks you for this work. Also can you elaborate on compound trigger with example.

[siddhartharao]

Sir, can we use pre defined error code in any user defined exception.

For Ex : ORA-01476 is Zero Divide Exception.

Can we use this zero divide exception error code as a part of Raise application error or Pragma exception_init?

[shaikrasheed]

How can I explain a project in interview