topic IWorkspace.ExecuteSQL with stored procedure blocks the table. in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/iworkspace-executesql-with-stored-procedure-blocks/m-p/557961#M15066 <HTML><HEAD></HEAD><BODY><P>I try to run a stored procedure from C# with ArcObjects 10.3 in Visual Studio 2013 debug mode.</P><P></P><P>pWorkspace.ExecuteSQL ("execute procedure procedure_name(paramater);");</P><P></P><P>When the procedure is executing(lets say 15 minutes) I CANNOT read the table that is updated in the procedure.</P><P>But when I am running (lets say 15 minutes) the procedure from database (Informix) I CAN read the table updated in the procedure.</P><P></P><P>What is the reason and how can I read the table when the procedure is executing?</P></BODY></HTML> Tue, 22 Sep 2015 06:12:58 GMT MarkMindlin 2015-09-22T06:12:58Z IWorkspace.ExecuteSQL with stored procedure blocks the table. https://community.esri.com/t5/arcobjects-sdk-questions/iworkspace-executesql-with-stored-procedure-blocks/m-p/557961#M15066 <HTML><HEAD></HEAD><BODY><P>I try to run a stored procedure from C# with ArcObjects 10.3 in Visual Studio 2013 debug mode.</P><P></P><P>pWorkspace.ExecuteSQL ("execute procedure procedure_name(paramater);");</P><P></P><P>When the procedure is executing(lets say 15 minutes) I CANNOT read the table that is updated in the procedure.</P><P>But when I am running (lets say 15 minutes) the procedure from database (Informix) I CAN read the table updated in the procedure.</P><P></P><P>What is the reason and how can I read the table when the procedure is executing?</P></BODY></HTML> Tue, 22 Sep 2015 06:12:58 GMT https://community.esri.com/t5/arcobjects-sdk-questions/iworkspace-executesql-with-stored-procedure-blocks/m-p/557961#M15066 MarkMindlin 2015-09-22T06:12:58Z