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
- 3827 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
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to convert raw data type into text in oracle? Explain
Why packages are used in oracle?
what is the difference between substr and instr function in oracle?
How to update values on multiple rows in oracle?
What to do if the binary spfile is wrong for the default instance?
How can I see all tables in oracle?
Explain alias?
How to do a full database export?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is rowid and rownum in oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to create an oracle testing table?
What are the different pseudo commands? Explain in general?
How to assign a table row to a record variable?
