Tuesday, 22 September 2020

ORA-01436: CONNECT BY loop in user data

            SELECT CASE

                     WHEN CONNECT_BY_ISLEAF = 1 THEN 0

                     WHEN LEVEL = 1 THEN 1

                     ELSE -1

                  END

                     AS status,

                  LEVEL,

                  menu_desc AS title,

                  DECODE (0, NULL, 'fa-bars', 'fa-file') AS icon,

                  child_node AS VALUE,

                  menu_desc AS tooltip,

                  APEX_UTIL.prepare_url (

                        'f?p='

                     || :app_id

                     || ':'

                     || page_no

                     || ':'

                     || :app_session

                     || ':::::')

                     AS link

             FROM (SELECT mennam AS menu_desc,

                          progcod AS parent_node,

                          modcod AS child_node,

                          progmid AS page_no

                     FROM menumst)

       START WITH child_node = 0

       CONNECT BY PRIOR parent_node = child_node

ORDER SIBLINGS BY parent_node;


I have faced ORA-01436: CONNECT BY loop in user data error

1 comment:

ORA-01436: CONNECT BY loop in user data

            SELECT CASE                      WHEN CONNECT_BY_ISLEAF = 1 THEN 0                      WHEN LEVEL = 1 THEN 1                   ...