Stored procedure not inserting rows tMssqlSp

[Cherichoc-]

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-]

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

[TRF · Accepted solution]

Is Autocommit option activated on tDBConnecction?