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 Posted / 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 |
Post New Answer View All Answers
What is data block in Oracle?
How to load excel data sheet to oracle database
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to list all tables in your schema?
What is a proxy class?
How to fetch the row which has the max value for a column?
How can I combine multiple rows into a comma-delimited list in oracle?
What is the use of file param in imp command?
Explain the use of grant option in exp command.
What is an anonymous block?
What are the original export and import utilities?
Explain the importance of .pll extension in oracle?
What is the difference between hot backup and cold backup in oracle?
How to see the table columns used in an index?
Explain the difference between a procedure and a function? What do you understand by those terms?