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 is difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

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

3 Answers   Scan Steel,

---

what is latest version in reports

8 Answers  

---

What is sca and how is it useful?

0 Answers  

---

How to print multi currency,multi language in xml?

1 Answers  

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers  

---

tell my any difficult situtation you solved in your experience in your company?

0 Answers   Accenture,

---

What are documents and test cases u followed.

2 Answers   Accenture,

---

HOW CAN U KNOW TABLE IS REGISTERD IN APPS?

3 Answers  

---

In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers  

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---