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
- 3117 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 |
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
What is Partitions in Table ?
13. Display the second to fifth characters in each client name.
candidate key is subset of super key but not vice-verse explain
WHT ARE THE AGGREATE FUNCTIONS?
Is it possible to enter only time value into a column of a table in sql?
what are actual and formal parameters?
What is tns name?
Can group functions be used in the order by clause in oracle?
Where do you use decode and case statements?
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.
How to speed up webrick?
Oracle General 
