In interface process we have 1000 records i want to commit every 100 records h

In interface process we have 1000 records i want to commit
every 100 records how? How i can commit every 100 records?

Question Posted / chandrasekhar.bs

2 Answers
8753 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In interface process we have 1000 records i want to commit every 100 records how? How i can commit..

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

Is This Answer Correct ?

15 Yes

1 No

In interface process we have 1000 records i want to commit every 100 records how? How i can commit..

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.