-- CREATE TABLE XXX (x INT);
-- DELETE XXX;

-- set serveroutput on

create or replace procedure checkReplaceableSQL
AS
BEGIN
  DECLARE
  stm varchar2(25000);
  BEGIN
  stm:=GET_SQL_TEMPLATE();
  stm:=REPLACE(stm,'${SQLPart}','INTO XXX SELECT');
  stm:=REPLACE(stm,'${Param1}','1');

  DBMS_OUTPUT.PUT_LINE(stm);
  EXECUTE IMMEDIATE stm;
  END;
END;


set serveroutput on
EXEC checkReplaceableSQL();

-- SELECT * FROM XXX;

CREATE OR REPLACE FUNCTION GET_SQL_TEMPLATE return varchar
IS
BEGIN
  DECLARE
  stm VARCHAR2(2000);
  BEGIN
    stm:='INSERT ${:SQLPart} 1 FROM DUAL WHERE 1 = ${:Param1}';
    RETURN stm;
  END;
END
;