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

[SunilPalkar]

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 !!!

[ReneRubalcava]

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.

[ManishkumarPatel · Accepted solution]

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.N...

Hope this helps.

Regards,
Manish

[SunilPalkar]

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.