ORA-30009 may be raised for certain CONNECT BY queries.
Rediscovery Notes:
If an ORA-30009 is raised and the CONNECT BY query returns a constant value
then this may be root cause if the CONNECT BY is a filter subquery.
Workaround
None
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.
References
Bug:11805372 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article