topic Re: Using ST_length or ST_Y operator/function with in Oracle trigger in Data Management Questions

Using ST_length or ST_Y operator/function with in Oracle trigger

YogeshShah — Thu, 29 Mar 2012 17:50:29 GMT

I could use following statement without any problems(Using SQL navigator)

select st_x(st_startpoint(s.shape)),st_Y(st_startpoint(s.shape)),st_X(st_endpoint(s.shape)),st_Y(st_endpoint(s.shape)),st_length(s.shape) from san_pipe s

I am trying to create an update trigger on san_pipe to get a length and coordinates and populate in feature class columns as under

:new.length_calc := st_length(:new.shape)

I am not able to compile the trigger and receive invalid use of operator error.

Are they not allowed to be used in trigger? Am I missing anyting? I also tried using sde.st_length

Re: Using ST_length or ST_Y operator/function with in Oracle trigger

YogeshShah — Thu, 29 Mar 2012 19:12:31 GMT

It works now!

Used select st_length(:new.shape) into vlength from dual;
:new.length_calc := vlength;

Have fun!

Re: Using ST_length or ST_Y operator/function with in Oracle trigger

VinceAngelo — Thu, 29 Mar 2012 19:38:45 GMT

You should prefix operators for ArcSDE ST types and functions with "SDE." since
Oracle has reserved the synonyms for the SDO_GEOMETRY types.

- V