Column%type parameter
SQL> SQL> create table myTable ( 2 col varchar2(10) 3 ); Table created. SQL> SQL> SQL> SQL> SQL> create or replace procedure ADD_NUM_ROW(p_col myTable.COL%TYPE) is 2 begin 3 insert into myTable values (p_col); 4 end; 5 / Procedure created. SQL> SQL> SQL> show errors; No errors. SQL> SQL> SQL> drop table myTable; Table dropped. SQL> SQL> SQL>