topic Re: Is it possible to : Call Stored procdeure in ArcGIS JSAPI (3.x) ? in ArcGIS JavaScript Maps SDK Questions

Is it possible to : Call Stored procdeure in ArcGIS JSAPI (3.x) ?

SunilPalkar — Fri, 25 Oct 2013 13:00:48 GMT

Hello All,

As per the new version is released for ArcGIS JSAPI.

I would like to know whether its possible to Call/execute Stored procdeure in ArcGIS JSAPI (3.x) ?

I searched a lot on ESRI forum but looks like its not possible still waiting for an miracle : )

If not then ESRI team please explain the reason.

thanks a lot in advance !!!

Re: Is it possible to : Call Stored procdeure in ArcGIS JSAPI (3.x) ?

ReneRubalcava — Fri, 25 Oct 2013 14:06:22 GMT

You'd have to expose the stored procedure via your own web service. You could also do it with an SOE or a GP service.

Re: Is it possible to : Call Stored procdeure in ArcGIS JSAPI (3.x) ?

ManishkumarPatel — Fri, 25 Oct 2013 15:07:38 GMT

Hi Sunil,

Kasa aahes re 🙂

Directly calling a stored procedure using ArcGIS API for JavaScript, it is not possible as of now. Although you can write a webservice to communicate with the database (stored procedures) and get the results as JSON Object.

For reference check this link:
http://www.aspsnippets.com/Articles/Calling-server-side-methods-using-JavaScript-and-JQuery-in-ASP.Net.aspx

Hope this helps.

Regards,
Manish

Re: Is it possible to : Call Stored procdeure in ArcGIS JSAPI (3.x) ?

SunilPalkar — Tue, 29 Oct 2013 12:09:39 GMT

Thanks for your reply.

I want actually call from query layer looks like not possible

OR Something like that my map will be update dynamically.. if I update the stored procedure..

You'd have to expose the stored procedure via your own web service. You could also do it with an SOE or a GP service.