[GIS] How to register a Stored Procedure in ArcSDE

arcgis-10.1arcgis-serverenterprise-geodatabasesql server

I just registered a SQL Server view with ArcSDE through 

sdetable -o register [...].

I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view?

EDIT

It seems that to register a stored procedure, it is required to have a "stable" database object: the definition of the stored procedure by itself it is just a piece of code that has no sense until it is executed with some input parameters.

Ok, so, if we consider the stored procedure as a "data collection generator", how would you execute this code with the input parameters, catch the tabular data output and register it to ArcSDE? What would you use? Some kind of ArcGIS processing?

Please, could you provide any example or guidelines for this process?

Thanks!

Best Answer

Well, the stored procedure does not make "any special calculation" it just builds a dataset in function of some input parameters the user stablishes. Nothing sophisticated, though. The thing is that I need ArcGIS to access that object, but that object does not exist until I establish those input parameters, so... Anyway, I found a "workaround" with publishing all required parameters with views and filtering them later

Related Question