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.

how to enable Zoom function and steps?

1 Answers   Patni,

---

What is Summary columns?

1 Answers  

---

wht is the use of Xml reports over reports6i?

5 Answers  

---

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  

---

where is setup of business group done?

2 Answers   TCS,

---

Attribute data types?

2 Answers  

---

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

---

hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.

1 Answers   BirlaSoft,

---

What is OM Cycle and What do u mean by Alternate Item

3 Answers   IBM,

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

What is Formula Column?

4 Answers  

---

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 Answers  

---