Oracle插入数据后返回自增列值

/oracle insert 返回自增ID/

create or replace procedure getid(v_id out number)

as

v_sql varchar2(500);

begin

v_sql:='insert into test values(7,''jack'') returning id into :1' ;

execute immediate v_sql

returning into v_id;

end;