create or replace procedure new
is
BEGIN
EXECUTE IMMEDIATE 'insert into reuben values(:name,:num);
end;
/

SQL> create table ruben (col1 varchar2(31), col2 number);

Table created.

SQL> CREATE OR replace PROCEDURE Foobar(name_in VARCHAR2, 
                                   num_in  NUMBER) 
IS 
BEGIN 
    INSERT INTO ruben 
    VALUES     (name_in, 
                num_in); 
END; 

/  2    3    4    5    6    7    8    9   10  

Procedure created.

SQL> exec foobar('NEWBIE',0);

PL/SQL procedure successfully completed.

SQL> 

SQL> insert into reuben values('&name',&num);
Enter value for name: michel
Enter value for num: 1
insert into reuben values('michel',1)
            *
ERROR at line 1:
ORA-00942: table or view does not exist