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
- 3434 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 suggestions do you have to reduce the network traffic?
How to start a new transaction in oracle?
how to find the n'th highest salary from emp ?
How to drop an index?
What is oracle join syntax?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
What is STATSPACK tool?
How to create a new table by selecting rows from another table?
what is shell?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Can anyone give me information about oracle certification
Can select statements be used on views in oracle?
Oracle General 
