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
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What are the differences between char and nchar in oracle?
How do we get field details of a table?
Explain oracle insert into command?
Explain the use of online redo log files in oracle.
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to call a stored function with parameters?
List the types of joins used in writing subqueries?
What would you do with an in-doubt distributed transaction?
Is insert autocommit in oracle?
What is oracle open database communication (odbc)?
Difference between hot backup vs. Cold backup?
Calculate difference between 2 date / times in oracle sql?
Can select statements be used on views in oracle?
What is the implicit cursor in oracle?