topic Re: Bulk Update records in Oracle DB using stored procedure in Talend Studio

Bulk Update records in Oracle DB using stored procedure

SK1694344715 — Fri, 15 Nov 2024 21:17:39 GMT

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 — Mon, 30 Oct 2023 06:57:05 GMT

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 — Mon, 30 Oct 2023 15:29:22 GMT

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