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
- 3877 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 spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain coalesce function?
How can we find the size of a database?
How to define a procedure inside another procedure?
How to bring a tablespace offline?
what is pragma?
What is a schema in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What are the different types of databases?
Explain the types of exception?
what is primary key and foreign key when and where have to use
what is the difference between UNION AND UNIONALL
Oracle General 
