Wrong way to reference parameters
SQL>
SQL>
SQL> create table t(
2 n number,
3 parm varchar2(20)
4 )
5 /
Table created.
SQL>
SQL> create or replace
2 procedure insert_into_t(
3 p_parm1 in number,
4 p_parm2 in number ) is
5 begin
6 insert into t values ( p_parm1, 'p_parm1' );
7 insert into t values ( p_parm2, 'p_parm2' );
8 end insert_into_t;
9 /
Procedure created.
SQL>
SQL> begin
2 insert_into_t(1,2);
3 end;
4 /
PL/SQL procedure successfully completed.
SQL>
SQL> select * from t;
N PARM
---------- --------------------
1 p_parm1
2 p_parm2
SQL>
SQL> drop table t;
Table dropped.
Related examples in the same category