Is This Content Helpful?
We're glad to know this article was helpful.
An ORA-028579 error can be encountered when executing a query with an st_geometry attribute.
WHERE id = 4 AND cycle_type = '1')) AS shape
WHERE id = 4 AND cycle_type = '1')) = 1;
This issue is due to an Oracle bug. Refer to My Oracle Support for more information.
Oracle Bug: 8507458 "ODCIindexstart dump on select on a column which has domain index created."
If the problem described in this article is encountered, a new folder and call stack trace file will be automatically generated by Oracle in the $ORACLE_HOME/rdbms/log/hs_core_#### folder (where #### is an auto-generated number). This call stack trace can be compared to the one mentioned in the Oracle bug, or it can be provided to Oracle to determine if the same issue is being encountered.
This issue is fixed in the 22.214.171.124 Patch Set and some other patch releases. Refer to Oracle's support documentation for full details.