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
- 3922 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
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is a table index in oracle?
How remove data files before opening a database?
How to select some rows from a table in oracle?
How to use "out" parameter properly?
How to Truncate Table in Oracle
How many types of cluster table in Oracle?
interview questions with answer for cts
can u plz provide me oca sql dumps please i need them
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Explain user account with reference to oracle.
How can we view last record added to a table?
What is a user role in oracle?
Explain about your project and its relation to the current job position you are applying to?
How to use "startup" command to start default instance?
