Answer / prasad t

there is an option in sqlldr scott/tiger rows=100
rows menas it will commit the rows
rows=100 meands it commits the 100 rows after the insertion

Answer / prasad reddy

BEGIN
IF l_return_status = 'Y'
THEN
UPDATE xxdc_inv_mtl_item_stg_t
SET process_status = 2
WHERE ROWID = cur_rec.ROWID;

l_txn_validated := l_txn_validated + 1;
ELSIF l_return_status = 'E'
THEN
UPDATE xxdc_inv_mtl_item_stg_t
SET process_status = 3,
error_message = error_message ||
l_error_msg
WHERE ROWID = cur_rec.ROWID;

l_txn_failed := l_txn_failed + 1;
END IF;

IF MOD (l_txn_inserted, p_commit_point) = 0
THEN
COMMIT;
END IF;


Pls look at the above code it may help you out.

Any how here i am giving explanation

take the count of inserted rows and mod by 100 or 1000 or
2000 wat ever you want and do commit;

simple

code

IF MOD (l_txn_inserted, p_commit_point) = 0
THEN
COMMIT;
END IF;

Regards,
-Prasad.

What are the Major differences between appcore.pll and appcore2.pll

5 Answers   Infosys, Sierra Atlantica,

---

What do you understand by soa?

0 Answers  

---

about TCA architecture

1 Answers   TCS,

---

testing tools?

0 Answers   BirlaSoft, Convergys,

---

Can you have two stored functions with in the same name?

3 Answers  

---

What is Formula Column?

4 Answers  

---

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

---

After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,

---

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

---

What is count(*) from po_vendors(any table)?

0 Answers  

---

tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,

---

How do u identity its name of report?

3 Answers  

---