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
- 3765 Views
- MasterCard, I also Faced
- E-Mail Answers
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
How can we find out the duplicate values in an oracle table?
How to view the tablespaces in the current database?
How to define a cusotmer as a supplier in ORACLE R12
how may join possible between (requisition with purchase order)
What is the difference between sharding and replication?
Explain the use of indexes option in imp command.
What are the components of logical database structure in oracle database?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is a parameter file in oracle?
Does oracle database need java?
What is the fastest query method to fetch data from the table?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain the features of oracle?
How to rollback the current transaction in oracle?
