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
- 3826 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 |
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
How to upsert (update or insert into a table)?
Explain overloading. Can functions be overloaded?
What are the logical operations?
if you update view? where we store the data?
Compare and contrast between sql and sql server and explain its various functions?
How to start a specific oracle instance?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How to list all user accounts in oracle?
How to drop an existing view in oracle?
What is a SNAPSHOT ?
How to recover a dropped table in oracle?
Oracle General 
