In 12c you can run a pl/SQL function in a WITH clause as highlighted in
Carl Dudley's presentation at #OUG_SCOT
Regards, JT
On Wed, 22 Jun 2016, 21:39 Sayan Malakshinov, <xt.and.r@xxxxxxxxx> wrote:
--
Hi Ingrid,
I'm not sure that is good idea to use DML for such performance testing,
but you can do it with "pragma autonomouse_transaction like this:
create or replace function getruntime
return number
IS
dmlruntime number(8);
begin
declare
pragma autonomous_transaction;
begin
dmltest(dmlruntime);
rollback;
end;
return dmlruntime;
end getruntime;
/
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org