如何实现在Oracle插入一条记录返回主键

如题
ps：该主键不是序列，只是普通的自增列

---

SQL> set serveroutput on
SQL> declare
  2    v_id test.id%type;
  3  begin
  4    insert into test values(7,'AC米兰') returning id into v_id;
  5    dbms_output.put_line(v_id);
  6  end;
  7  /
7

PL/SQL 过程已成功完成。

SQL>

---

INSERT INTO a VALUES (xxx, xxx)
RETURNING 列名 INTO 变量;

---

引用

SQL> set serveroutput on
SQL> declare
  2     v_id test.id%type;
  3  begin
  4     insert into test values(7,'AC米兰') returning id into v_id;
  5     dbms_output.put_line(v_id);
  6  end;
  7  /
7

PL/SQL 过程已成功完成。

SQL>

up,DBA.

---

create or replace procedure getid(v_id out number)
as
  v_sql varchar2(500);

  begin

      v_sql:='insert into test values(8,''tom'') returning id into ' || v_id;
      execute immediate v_sql;
      exception
        when others then
      &nb