add tag
User 1791
I have sample data and a query that works as expected in my on-prem Oracle 18c database.

Sample data and query: (hint: skip down to statement #12)

The query:

    b.objectid as point_object_id, 
    c.objectid as polygon_object_id
    TABLE(sdo_join('PNT','SHAPE','PLY','SHAPE')) a,
    PNT b,
    PLY c
    a.rowid1 = b.rowid
AND a.rowid2 = c.rowid
AND SDO_GEOM.RELATE (b.shape, 'ANYINTERACT', c.shape, 1.0) = 'TRUE'

I get errors in db<>fiddle:

ORA-13236: internal error in R-tree processing: [SDO_Join in active txns not supported]
ORA-06512: at "MDSYS.SDO_JOIN", line 664
ORA-06512: at "MDSYS.RTREEJOIN_IMP_T", line 21
ORA-06512: at "MDSYS.RTREEJOIN_IMP_T", line 16
ORA-06512: at line 1
ORA-06512: at "MDSYS.SDO_JOIN", line 628
ORA-06512: at line 1

I don't get those errors in my on-prem database. Any idea why the query fails in db<>fiddle (Oracle 18c)?
Top Answer
User 1791

I had to commit the sample data I created:

> [20.8 SDO_JOIN - Usage Notes](  
> Before you call SDO_JOIN, you must commit any previous DML statements in your session. Otherwise, the following error will be returned: `ORA-13236: internal error in R-tree processing: [SDO_Join in active txns not supported]`


Oracle Forum: [Query works in on-prem Oracle database, but not in online environment: ORA-13236 (SDO_Join)](

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.