PROCEDURE INTIALIZE_SECOND(DUMMY NUMBER)
AS
-- Variable declaration
V_LIST VARCHAR2(100);


BEGIN

SELECT VALUE INTO V_LIST FROM CONFIG_PARAMS
WHERE NAME = 'notf';

MERGE INTO TEMP ST USING
(SELECT EXT.KEY
FROM EXTN EXT, DETAILS D
WHERE EXT.KEY            = D.KEY
AND EXT.STATUS         IN V_LIST
) INNER_QUERY ON (ST.KEY = INNER_QUERY.KEY)
WHEN NOT MATCHED THEN
  INSERT
    (
      SEQ_NO,
      KEY,
      FLAG
    )
    VALUES
    (
      SEQ.nextval,
      INNER_QUERY.KEY,
      'Y'
    );
END INTIALIZE_SECOND;

SQL> PROCEDURE INTIALIZE_SECOND(DUMMY NUMBER)
  2  AS
  3  -- Variable declaration
  4  V_LIST VARCHAR2(100);
  5  
  6  
  7  BEGIN
  8  
  9  SELECT VALUE INTO V_LIST FROM CONFIG_PARAMS
 10  WHERE NAME = 'notf';
 11  
 12  MERGE INTO TEMP ST USING
 13  (SELECT EXT.KEY
 14  FROM EXTN EXT, DETAILS D
 15  WHERE EXT.KEY            = D.KEY
 16  AND EXT.STATUS         IN V_LIST
 17  ) INNER_QUERY ON (ST.KEY = INNER_QUERY.KEY)
 18  WHEN NOT MATCHED THEN
 19    INSERT
 20      (
 21        SEQ_NO,
 22        KEY,
 23        FLAG
 24      )
 25      VALUES
 26      (
 27        SEQ.nextval,
 28        INNER_QUERY.KEY,
 29        'Y'
 30      );
 31  END INTIALIZE_SECOND;
 32  /
PROCEDURE INTIALIZE_SECOND(DUMMY NUMBER)
*
ERROR at line 1:
ORA-00900: invalid SQL statement