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;
原文：http://www.cnblogs.com/mingjing/p/5123823.html