topic Re: Stored procedure in ArcGIS 10.1 in Data Management Questions

Stored procedure in ArcGIS 10.1

SunilPalkar — Thu, 13 Dec 2012 02:53:25 GMT

Hello All,

Can I use the Stored procedure in ArcGIS 10.1 ??

We have Sql server 2008r2 ,ArcGIS Server 10.1 and ArcGIS Desktop 10.1

I have gone through few links and ArcGIS help and I found that its not possible to use procedures in 10.1.. Actually I am using query layer in ArcGIS Desktop and publishing that layer to ArcGIS Server. All the data is stored in Sql Server.

We do not have ArcSDE 10.1 ( Support told that no need to install ArcSDE due to some advance functionality of 10.1..is that true??)

If anyone knows the ans then please let me know...

thanks in advance : )

Re: Stored procedure in ArcGIS 10.1

VinceAngelo — Thu, 13 Dec 2012 12:17:35 GMT

Query Layers execute SELECT statements. I doubt you could make them let the
stored procedure execute the SELECT for you. I believe both ODBC and ArcSDE
will allow you to execute stored procudures, though whether you can process
return rows is something you'd have to explore.

The "advance functionality" that obviates ArcSDE is Query Layers (which was part
of 10.0 as well). It is not necessary to run an application server to get access to
ArcSDE functionality (this has been true since 9.2), however, ArcGIS editing still
requires ArcSDE, as does versioning and replication.

- V

Re: Stored procedure in ArcGIS 10.1

SunilPalkar — Fri, 14 Dec 2012 02:59:17 GMT

@vangelo Thanks for you reply..I will check and let you know..