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
- 3864 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
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to create a single index for multiple columns?
How do I learn what codesets are available in oracle?
State any two functions of oracle?
What is a partition in oracle?
What is oracle update statement with inner join ?
What is difference between cartesian join and cross join?
Can we write dml statement in function in oracle?
What is where clause in oracle?
How many types of synonyms in Oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to export data with a field delimiter?
Can we create database in oracle using command line ?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Can you assign multiple query result rows to a variable?
