What is not a valid Oracle PL / SQL exception? - ProProfs Discuss
Advertisement

What is not a valid Oracle PL / SQL exception?

What is not a valid Oracle PL / SQL exception?

Change Image    Delete

Asked by Ibecruzin, Last updated: Nov 09, 2024

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

H. callum

H. callum

Extrovert, Psyched all the time.

H. callum
H. callum, Content Writer, BA, Birmingham, Albama

Answered Feb 07, 2019

In PL/SQL, an error condition is called an exception. Exceptions can be internally defined (by the runtime system) or user defined. Examples of internally defined exceptions include division by zero and out of memory. Some common internal exceptions have predefined names, such as ZERO_DIVIDE and STORAGE_ERROR. The other internal exceptions can be given names. You can define exceptions of your own in the declarative part of any PL/SQL block, subprogram, or package.

For example, you might define an exception named insufficient_funds to flag overdrawn bank accounts. Unlike internal exceptions, user-defined exceptions must be given names.

upvote 1 downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Apr 07, 2017

TWO_MANY_ROWS ORA-01422

TWO_MANY_ROWS is not the correct name for the TOO_MANY_ROWS exception
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.