I'm getting this errors when trying to run the query below:
ORA-44003: nombre de SQL no válido
ORA-06512: en "MDSYS.SDO_JOIN", línea 661
ORA-06512: en "SYS.DBMS_ASSERT", línea 215
ORA-06512: en "MDSYS.SDO_JOIN", línea 485
ORA-06512: en línea 1
44003. 0000 - "invalid SQL name"
*Document: Yes
*Cause: The input parameter string was not a valid simple SQL name.
*Action: Check with the DBMS_ASSERT spec to verify that the parameter
string is a valid simple SQL name.
This is my query:
select /*+ ordered */
b.cell_name as cell,
c.cell_name as ncell
from TABLE(sdo_join('OPTRF_CELLS_GEO','GEOM','OPTRF_CELLS_GEO','GEOM')) a,
OPTRF_CELLS_GEO b,
OPTRF_CELLS_GEO c
where
a.rowid1 = b.rowid
and a.rowid2 = c.rowid
** Running on "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0"