Bulk Update records in Oracle DB using stored procedure

[SK1694344715]

Hi All,

I need to update records(32K records) in Oracle DB using stored Procedure.

I wrote stored procedure in PLSQL and working fine in oracle DB(update all 32k records in one shot).

But when i try to use same SP invocation block in talend and running job, can see O/P is 1, but data is not updating for 32k records, need help.

NOTE: Not used any Bulk COllect in PLSQL block...

talend job:

tDB ROW-->tDBSP-->tDBCOMMIT.

ALOS, please provide sample Stored Procedure to bulk update records in same table.

Ex: Employee table with status_flag N to P needs to updated for 32k records, Please provide PLSQL sample block as well...

[Anonymous]

Hi

I am not an expert in Oracle stored Procedure, but I would like to to know what does tDBRow component do in your job?

Regards

Shong

[SK1694344715]

Simple, if you want to update or truncate or execute plsql block ,we use tdbrow component...

Search tdbrow usage in internet,you 2ill get itmmm