oracle11g - Converting "IN" keyword in Oracle procedure to equivalent logic in Netezza stored procedure -

how can following "in" keyword converted oracle pl/sql code below netezza sql code?

create or replace procedure sp1 (typ in varchar, str in varchar)  p1 varchar(50); p2 number(9); p3 char(1);  begin   -- code goes here  end sp1 

netezza's parameter list input only, , referenced position.

you link positional inputs meaninful names alias in declare block. these parameters constant in scope of procedure.

the p_ naming style convention only, , meant remind constant. variables prefixed v_.

here's quick mapping of netezza code.

create or replace procedure sp1 (varchar(any), varchar(any)) returns integer language nzplsql begin_proc declare p_typ alias $1; p_str alias $2;  v_1 varchar(50); v_2 bigint;  -- changed valid netezza example v_3 char(1);  begin  -- code goes here    end;  end_proc;