Questions tagged [stored-procedure]

a stored procedure is a set of precompiled SQL statements that are used to perform a defined query.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

Use custom SQL-functions within a WFS stored query (filter)

I want to set up a WFS (GeoServer) returning features which are matching a (given) term / name in a phonetic way by using a stored Query. I've got a SQL function which can be used as an operator for ...
1
vote
1answer
120 views

Execute Oracle stored procedure from ArcSDESQLExecute

I'm attempting to execute an Oracle 12c stored procedure using ArcSDESQLExecute: import arcpy egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\con1.sde") sql = '''execute update_sle (...
0
votes
0answers
72 views

GeoServer Sql Server Stored Prc

I'm sorry this might be duplicate. I'm trying to call stored proc with sql server. I saw this question which says its not possible but its a 5 yr old question and thought I'd check if there have been ...
4
votes
2answers
530 views

Alias for postgis function is really slow

I have created an alias for st_expand function like this CREATE OR REPLACE FUNCTION expand( geom geometry, value double precision) RETURNS geometry AS $BODY$ DECLARE my_geom geometry; BEGIN ...
3
votes
2answers
337 views

Is there a SQL Server package similar to Oracle's SDO_CS?

I see that Oracle's SDO_CS package is able to do datum transformations. I'd like to do datum transformations in SQL Server. I searched, but have not found something like this for SQL Server. Is ...
7
votes
0answers
164 views

Is it possible to add an ArcGIS attachment to a row in Oracle using oracle stored procedures? [closed]

So far I have been able to attach files to features within a featureclass using the python tools and ArcObjects. Within Oracle I have been able to add features with geometries using the ST_Geometry ...