AS

SELECT *

  FROM TABLE( MULTISET (

        SELECT A.V_UMENUID, A.V_MENUID, A.N_SEQNO, A.V_MENUNM,

               (SELECT A.N_SEQ_LEVEL - N_SEQ_LEVEL

                  FROM SSM_MENU

                 WHERE V_MENUID = 'S000001' ) AS N_TREE_LEVEL,

               A.N_SEQ_LEVEL,      

               A.V_HIERARCHY, A.V_PAGEID,

               NVL(B.V_PAGE_URL,'') AS V_PAGE_URL,

               A.V_MENUID AS V_PAGE_MENUID

          FROM SSM_MENU A LEFT OUTER JOIN SSM_PAGE B

            ON A.V_PAGEID = B.V_PAGEID

         WHERE NVL(A.V_FLAG_USE, 'Y') = 'Y'

           AND A.V_HIERARCHY LIKE '%.S000001.%') ) MENU

위에 쿼리를 시행하면 아래의 에러 메시지가 나오는데요.. 이유가 뭘까요..

view 생성하는넘 빼고 돌리면 잘나옵니다.. 알려 주세요.. 여렵다 informix ㅠ0ㅠ