topic Re: Difference between sde.st_within and sde.st_relation_operators.st_within_f in Data Management Questions https://community.esri.com/t5/data-management-questions/difference-between-sde-st-within-and-sde-st/m-p/29842#M1595 <HTML><HEAD></HEAD><BODY><SPAN>Hi Tony,</SPAN><BR /><BR /><SPAN>It sounds like you might be hitting an issue. The "_f" functions are for use with stored procedures and/or triggers. See this KB article for more details:</SPAN><BR /><BR /><A href="http://support.esri.com/en/knowledgebase/techarticles/detail/36094">HowTo:&nbsp; Leverage st_geometry operators in Oracle's PL/SQL</A><BR /><BR /><SPAN>Would you be able to open an incident with technical support please, so we can figure out what the problem is?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Tue, 05 Mar 2013 22:51:46 GMT ForrestJones 2013-03-05T22:51:46Z Difference between sde.st_within and sde.st_relation_operators.st_within_f https://community.esri.com/t5/data-management-questions/difference-between-sde-st-within-and-sde-st/m-p/29841#M1594 <HTML><HEAD></HEAD><BODY><SPAN>I was using the following in an Oracle where clause:</SPAN><BR /><SPAN>[INDENT]sde.st_within(op.shape, z.shape) = 1[/INDENT]</SPAN><BR /><BR /><BR /><SPAN>Most of the time the statement would work but occasionally I would either get a 'Error generating shape (shape2)' or a 'Error changing coordref (shape2)' error</SPAN><BR /><BR /><SPAN>After much frustration I changed the statement to sde.</SPAN><STRONG>st_relation_operators</STRONG><SPAN>.st_within</SPAN><STRONG>_f</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>So far no errors.</SPAN><BR /><BR /><SPAN>Can anyone explain the differences between the two ways to call the st_within function?</SPAN></BODY></HTML> Fri, 08 Feb 2013 19:11:54 GMT https://community.esri.com/t5/data-management-questions/difference-between-sde-st-within-and-sde-st/m-p/29841#M1594 TonyGroeneveld 2013-02-08T19:11:54Z Re: Difference between sde.st_within and sde.st_relation_operators.st_within_f https://community.esri.com/t5/data-management-questions/difference-between-sde-st-within-and-sde-st/m-p/29842#M1595 <HTML><HEAD></HEAD><BODY><SPAN>Hi Tony,</SPAN><BR /><BR /><SPAN>It sounds like you might be hitting an issue. The "_f" functions are for use with stored procedures and/or triggers. See this KB article for more details:</SPAN><BR /><BR /><A href="http://support.esri.com/en/knowledgebase/techarticles/detail/36094">HowTo:&nbsp; Leverage st_geometry operators in Oracle's PL/SQL</A><BR /><BR /><SPAN>Would you be able to open an incident with technical support please, so we can figure out what the problem is?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Tue, 05 Mar 2013 22:51:46 GMT https://community.esri.com/t5/data-management-questions/difference-between-sde-st-within-and-sde-st/m-p/29842#M1595 ForrestJones 2013-03-05T22:51:46Z