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 meant by bind parameter?

2 Answers   Satyam,

---

why we can use synonym?

6 Answers  

---

What is function?

2 Answers   Motorola,

---

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

---

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---

---

Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  

---

What is sca and how is it useful?

0 Answers  

---

in ap_terms table what data will be stored

2 Answers   Wipro,

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

---

what is the data type of lexical parameter?

5 Answers   Wipro,

---

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,

---