Cause
An attempt was made to specify a subquery in a CONNECT BY clause.
Action
Remove the subquery or move it to the WHERE clause.
Oracle 26ai
ORA-01473
Error Message
Subqueries cannot be specified in CONNECT BY clause.