ORA-13238
spatial journal cache enabled; query requires transaction commit
Cause
The spatial transaction journal cache was enabled. When enabled, spatial functions that require use of the spatial index could not be used when uncommitted transaction data existed.
Action
Commit or roll back the current transaction, or flush the spatial transaction journal cache using the PL/SQL "SDO_UTIL.INVALIDATE_GTT_CACHE" procedure.
ORA-13238
spatial journal cache enabled; query requires transaction commit
Cause
The spatial transaction journal cache was enabled. When enabled, spatial functions that require use of the spatial index could not be used when uncommitted transaction data existed.
Action
Commit or roll back the current transaction, or flush the spatial transaction journal cache using the PL/SQL "SDO_UTIL.INVALIDATE_GTT_CACHE" procedure.
ORA-13238
spatial journal cache enabled; query requires transaction commit
Cause
The spatial transaction journal cache was enabled. When enabled, spatial functions that require use of the spatial index could not be used when uncommitted transaction data existed.
Action
Commit or roll back the current transaction, or flush the spatial transaction journal cache using the PL/SQL "SDO_UTIL.INVALIDATE_GTT_CACHE" procedure.
