ORA-01436: CONNECT BY loop in user data
Hi Good day,
im encountering ORA-01436: CONNECT BY loop in user data, but i don't know what trigger this issue,
ORA-01436: CONNECT BY loop in user data
ORA-12012: error on auto execute of job "VISTA"."DBMS_JOB$_101"
ORA-01436: CONNECT BY loop in user data
ORA-00604: error occurred at recursive SQL level 1
as per checking in the trace file this sql select is causing the issue. ---- Current SQL Statement for this session (sql_id=5dqz0hqtp9fru) -----
select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 <<<<<<<<< SQL failing with ORA-01436 Error