PROCEDURE sp_directUpdate(COL C%ROWTYPE) IS
sql_stmt  VARCHAR2(200);
col_names VARCHAR2(200);
BEGIN

   EXECUTE IMMEDIATE 'INSERT INTO T1(SELECT COL.F0, COL.F1 FROM DUAL)';

END IF;

END;

EXECUTE IMMEDIATE 'INSERT INTO T2(SELECT COL.F0, COL.F1, COL.F4 FROM
  DUAL)';