create or replace procedure do_insert
  (p_in_data in number, p_pk_value out number)
is
begin
  -- pk column is populated via a sequence in a trigger
  insert
    into t (non_pk_column)
    values (p_in_data)
    returning pk_column into p_pk_value;
end;