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.

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

What is ERP? Architecture of apps?

3 Answers   TCS,

---

When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

---

in one report using two layout models.if yes how to do

4 Answers   Covansys,

---

what are the default arguments for pl/sql program?

1 Answers  

---

how can u find the status in po?

1 Answers  

---

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,

---

What do you understand by soa?

1 Answers  

---

what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,

---

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

---