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
- 3770 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 |
Explain the difference between sap and oracle?
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
How to handle a single quote in oracle sql?
What is a Data File ?
Explain oracle instance.
can a table has a column that has only view data and in other columns we can change data?
what is the difference between simple view and complex view?
Difference between cartesian join and cross join?
How to fetch the row which has the max value for a column?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What is recovery manager in Oracle?
Oracle General 
