Re: Simple (?) PL/SQL help

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_at_gmail.com> 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
>

-- 
Regards,

John

--
http://www.freelists.org/webpage/oracle-l