When I try to execute the following PL-SQL code I have right results:
But when I try to compile a store-procedure using a similar code I get a compilation error:
What I have to do to fix this error?
you must use this reference of intersect operation in PLSQL code: "sde.st_relation_operators.st_intersects_f"
this is because PL/SQL requieres referencing the underlying functions by fully qualifying their appropiate package and function name.
look this link:
36094 - Leverage st_geometry operators in Oracle's PL/SQL
My Oracle Support
Compiling In SQL Developer Throws "PLS-00707: Unsupported Construct Or Internal Error" (Doc ID 1521171.1)
In this Document
sql developer version: 3.2.20.09Database version: 184.108.40.206
Attempting to compile Function/Prucedure/Package in SQL Developer throws the following error:
PLS-00707: unsupported construct or internal error 
This issue is not occuring in sqlplus. This issue occurs only for the 11g/11gr2 Database on SQL Developer.
It seems to be caused by the parameter PL/SCOPE variable when it uses the value "IDENTIFIERS:ALL".SQL Developer during connection establishing changes the session parameter PLSCOPE_SETTINGS from IDENTIFIERS:NONE (default) to IDENTIFIERS:ALL. Same error was received in SQL PLUS when issuing an "alter session set PLSCOPE_SETTINGS=IDENTIFIERS:ALL".
More about PL/Scope can be found here:http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htmhttp://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams178.htm
1. Go to Preferences in SQL Developer.2. Then go to Tools -> Preferences -> Database -> PL/SQL Compiler3. Change the "PLScope identifiers" from All to None4. Restart the SQL Developer.
Retrieving data ...