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>
|