Hello,
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?
Marcelo...
Hi Marcelo
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: 11.2.0.3
Attempting to compile Function/Prucedure/Package in SQL Developer throws the following error:
PLS-00707: unsupported construct or internal error [2603]
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.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
