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
- 3120 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 |
What is the difference between primary key and unique key and foreign key in oracle?
Explain enable novalidate constraint.
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
what is null value?
what is kernel?
what is insert all statement in sql
How to get execution statistics reports on query statements?
What is ADDM Advisor in Oracle?
Is oracle a relational database?
Can multiple cursors being opened at the same time?
what is foreign key?
26. Display the earliest shipping date in the format: DD/MON/YYYY
Oracle General 
