Interested to Buy Any Domain ? << Click Here >> for more details...
There are set of records to be processed from staging table
into interface table. If one record fails the entire set of
data should be rejected.
- 3 Answers
- 9633 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh
we can use rollback operation in exception block
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sandeep
You can also use an extra columns for tracking error flag, error message. First you can validate the records and update that particular record with the above mentioned columns.
if you don't find any errors after validation then you can load them to interface tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / raghupal
No, only the particular record is not insert the interface tables.to check for this record, this record will insert in to the bad file & discord file
| Is This Answer Correct ? | 3 Yes | 2 No |
After deploying like forms,reports into server how we connect this forms,reports to web?
wht is difference between is and as varibales,while declaring procedure which is better?
Can 2 functions have same name & input parameters but differ only by return datatype ?
what is meant by anchoring?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
You are working with interfaces if client doesnot give any flat then what will u do?
Is SOB is attached with Business grp ?
what is the difference between %_all and %_f tables
what are the mandatory parameters in suppler Conversion?
What do you understand by concurrent programs?
why we can use synonym?
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
Oracle Apps Technical 
