How to use VARRAY in IN clause
629026Feb 25 2011 — edited Feb 25 2011My requirement goes like this
SS_ADDR_AVA_ARR is a VARRAY
SELECT SOURCE_NAME BULK COLLECT INTO SS_ADDR_AVA_ARR FROM SOURCE_SYSTEM_CONFIG_TABLE WHERE ADDR_DATA_AVAILABLE='Y';
I would like to check the values of VARRAY in a single shot instead of LOOPING,
But PL/SQL doesn't allow SUBQUERYING as below
EXIT WHEN V_DG.SOURCE_NAME NOT IN (SELECT * FROM TABLE(SS_ADDR_AVA_ARR AS VARCHAR2));
OR
IF V_DG.SOURCE_NAME NOT IN (SELECT * FROM TABLE(SS_ADDR_AVA_ARR AS VARCHAR2)) THEN
--CODE
END IF;
How to go ahead with this