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 sequence?
Explain drop constraint oracle?
What is oracle host variable?
What is the relationship among database, tablespace and data file?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Which environment variables are absolutely critical in order to run the OUI?
What is Reduced List of Values?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is translate in oracle?
Difference between cartesian join and cross join?
Differentiate between function and procedure in oracle.
How to pass parameters to procedures?
How to filter out duplications in the returning rows using 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.
What is hot backup and logical backup?