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
- 3752 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 to use "in" parameter properly?
What is a table index in oracle?
What happens if you lost a data file?
What exactly do quotation marks around the table name do?
How to load data from external tables to regular tables?
How to write a query with an inner join in oracle?
How to change system global area (sga) in oracle?
How to use subqueries with the in operator using oracle?
How to start instance with a minimal initialization parameter file?
What is a subquery in oracle?
What is a parameter file in oracle?
State and explain the different types of data models?
What is a tns file?
How to use "in out" parameter properly?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
