IWorkspace.ExecuteSQL with stored procedure blocks the table.

2668
0
09-21-2015 11:12 PM
MarkMindlin
Occasional Contributor III

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?

0 Kudos
0 Replies