SQL> CREATE OR REPLACE PROCEDURE testrob (par_deptno IN NUMBER)
  2  IS
  3    sql_stmt VARCHAR2(800);
  4  BEGIN
  5    sql_stmt := 'insert into dept (deptno, dname, loc) ' ||
  6                'select deptno, dname, loc ' ||
  7                'from dept ' ||
  8                'where deptno = ' || par_deptno;
  9
 10    EXECUTE IMMEDIATE sql_stmt;
 11  END;
 12  /

Procedure created.

SQL>
SQL> SELECT * FROM DEPT WHERE deptno = 10;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK

SQL>
SQL> EXEC testrob (10);

PL/SQL procedure successfully completed.

SQL>
SQL> COMMIT;

Commit complete.

SQL>
SQL> SELECT * FROM DEPT WHERE deptno = 10;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        10 ACCOUNTING     NEW YORK

SQL>

SQL> CREATE TABLE tblx
  2    (a NUMBER, b NUMBER, c NUMBER, d NUMBER, e NUMBER, acc_id NUMBER);

Table created.

SQL> CREATE TABLE tbltempdays AS SELECT * FROM tblx;

Table created.

SQL> INSERT INTO tblx (a, b, c, d, e, acc_id) VALUES (1, 2, 3, 4, 5, 10);

1 row created.

SQL> CREATE OR REPLACE PROCEDURE Testrob (accid IN NUMBER)
  2  IS
  3    sql_stmt VARCHAR2(800);
  4  BEGIN
  5    sql_stmt := 'insert into tblTempDays( a, b, c, d, e) ' ||
  6                ' select a, b, c, d, e FROM tblx ' ||
  7                ' WHERE ACC_ID = ' || accid;
  8
  9    EXECUTE IMMEDIATE sql_stmt;
 10
 11    COMMIT;
 12
 13  END;
 14  /

Procedure created.

SQL>
SQL> EXEC Testrob (10);

PL/SQL procedure successfully completed.

SQL>
SQL> SELECT * FROM tbltempdays;

         A          B          C          D          E     ACC_ID
---------- ---------- ---------- ---------- ---------- ----------
         1          2          3          4          5 NULL

  ' WHERE ACC_ID = :accid';

execute immediate sql_stmt using accid;