AnsweredAssumed Answered

IWorkspace.ExecuteSQL with stored procedure blocks the table.

Question asked by mik1971 on Sep 21, 2015

I try to run a stored procedure from C# with ArcObjects 10.3 in Visual Studio 2013 debug mode.

 

pWorkspace.ExecuteSQL ("execute procedure procedure_name(paramater);");

 

When the procedure is executing(lets say 15 minutes) I CANNOT read the table that is updated in the procedure.

But when I am running (lets say 15 minutes) the procedure from database (Informix) I CAN read the table updated in the procedure.

 

What is the reason and how can I read the table when the procedure is executing?

Outcomes