Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 3924 Views
- MasterCard, I also Faced
- E-Mail Answers
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 |
State all possible different index configurations a table can possibly have?
Can we protect our pl/sql source code?
How do you find current date and time in oracle?
What is currency type in database ?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Display Odd/ Even number of records?
List the types of joins used in writing subqueries?
What happens to the indexes if a table is recovered?
what is the bitmap index?
What is index in Oracle?
What happens in oracle commit?
How to Remove the 3rd highest salary person record from table?
Oracle General 
