SQL>
SQL>
SQL> create table t(
2 n number
3 )
4 /
Table created.
SQL>
SQL> create or replace procedure insert_into_t( p_parm in number ) is
2 begin
3 insert into t values ( p_parm );
4 end insert_into_t;
5 /
Procedure created.
SQL>
SQL> EXEC insert_into_t(12);
PL/SQL procedure successfully completed.
SQL>
SQL> select * from t;
N
----------
12
SQL>
SQL> drop table t;
Table dropped.
SQL>
SQL>