TOO_MANY_ROWSORA-01422When you use SELECT in a PL/SQL block, it's important to make sure that exactly one row will always be returned by your query. ... If more than one row is returned, the TOO_MANY_ROWS exception occurs.Single row SELECT returned more than one row.Example:create or replace procedure pro1(deptno in number)DECLARE V_NAME...
Wednesday, November 24, 2021
What is Exception Handling in PL/SQL?
What is Exception Handling in PL/SQL?An exception occurs when the PL/SQL engine encounters an instruction which it cannot execute due to an error that occurs at run-time. These errors will not be captured at the time of compilation and hence these needed to handle only at the run-time.For example, if PL/SQL engine receives an instruction to divide...