Difference between sde.st_within and sde.st_relation_operators.st_within_f

[TonyGroeneveld]

I was using the following in an Oracle where clause:
[INDENT]sde.st_within(op.shape, z.shape) = 1[/INDENT]


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

After much frustration I changed the statement to sde.st_relation_operators.st_within_f.

So far no errors.

Can anyone explain the differences between the two ways to call the st_within function?

[ForrestJones]

Hi Tony,

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:

HowTo:  Leverage st_geometry operators in Oracle's PL/SQL

Would you be able to open an incident with technical support please, so we can figure out what the problem is?

Thanks,