topic Stored procedure not inserting rows tMssqlSp in Talend Studio

Stored procedure not inserting rows tMssqlSp

Cherichoc- — Sat, 16 Nov 2024 02:49:38 GMT

I created a stored procedure that selects data from one table and inserts loop rows to another table

CREATE PROCEDURE [dbo].[forMark]
@MarkS int output
,@studentid INT output
,@n int =0

as

SELECT @studentid = studentid, @MarkS = [ marks]
FROM dbo.tempPersons
WHERE statuscode=0

while @n <@marks
begin
insert into dbo.tempMarks (studentid) values(@studentid)
set @n =@n+1
end

My talend

Cherichoc- — Tue, 31 Mar 2020 15:20:21 GMT

@nthampi @irahman @TRF @vapukov @fdenis please help out with a solution

TRF — Wed, 01 Apr 2020 14:31:55 GMT

Is Autocommit option activated on tDBConnecction?