if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
Answer / ana
Enclose the 61th line in a begin-exception-end block and in exception block have
when others then null;
so that when exception is raised in 61th line it will do nothing and continue with other lines of the 1000 line procedure.
eg:
Begin
Select * from emp ;
Exception
when others then
null;
End;
| Is This Answer Correct ? | 3 Yes | 0 No |
Can we store images in oracle database?
What are the different types of databases?
What is the purpose of save points in oracle database?
Explain the truncate in oracle?
What do you mean by group by clause?
What is a proxy class?
How to increment dates by 1 in oracle?
what is the use of composite key constraint?
Which is better Oracle or MS SQL? Why?
What is clusters ?
What language does oracle use?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,