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
- 3868 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 are the ansi data types supported in oracle?
What is a Data Dictionary ?
what are steps for interface? where is exchange rate defined in which table?
What is a initialization parameter file in oracle?
Can the default values be assigned to actual parameters?
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
How to create a new tablespace in oracle?
 How to use an oracle sequence generator in a mapping?
Explain oracle data types with examples?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
What is a data segment ?
What is tns service name?
Oracle General 
