Hi,
i have written application process code to cascade lov in tabular form. it displaying the error.
could you halp me to find the error?
// Application process code
DECLARE l_sql VARCHAR2(32700);
BEGIN IF APEX_APPLICATION.G_x01 IS NOT NULL THEN
APEX_UTIL.SET_SESSION_STATE('G_TEMP', APEX_APPLICATION.G_x01);
l_sql := 'select V.SEGMENT_VALUE AS RET, DESCRIPTION AS DIS
FROM ACT_COA_SEGMENT_MAS C,ACT_SEGMENT_VALUES_MAS V
WHERE C.SEGMENT_ID = V.SEGMENT_ID
AND C.SEGMENT_ID = 3
AND V.ACTIVE_FLG = 'Y'
AND C.ACTIVE_FLG ='Y'
AND V.PARENT_ID=:G_TEMP order by 1 ';
APEX_UTIL.JSON_FROM_SQL(l_sql);
ELSE
HTP.prn('{"row":[]}');
END IF;
APEX_UTIL.SET_SESSION_STATE('G_TEMP', NULL);
END;
// Error massage
ORA-06550: line 8, column 21:
PLS-00103: Encountered the symbol "Y" when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem
<> or != or ~= >= <= <> and or like like2
like4 likec between || multiset member submultiset
6. WHERE C.SEGMENT_ID = V.SEGMENT_ID
7. AND C.SEGMENT_ID = 3
8. AND V.ACTIVE_FLG = 'Y'
9. AND C.ACTIVE_FLG ='Y'
10. AND V.PARENT_ID=:G_TEMP order by 1 ';