RE: PL/SQL in SQL (12c feature)
Date: Mon, 19 May 2014 15:13:08 +0000
Message-ID: <D7864FA3E7830B428CB2A5A5301B63EE01723177C3_at_S7041VA005.soa.soaad.com>
Very cool. I will have to read up on that pragma.
Thanks!
Matt
-----Original Message-----
From: timseanhall_at_gmail.com [mailto:timseanhall_at_gmail.com] On Behalf Of Tim Hall
Sent: Monday, May 19, 2014 10:53 AM
To: McPeak, Matt
Cc: oracle-l_at_freelists.org
Subject: Re: PL/SQL in SQL (12c feature)
Depends if the stored PL/SQL is defined with PRAGMA UDF or not.
http://www.oracle-base.com/articles/12c/with-clause-enhancements-12cr1.php#pragma-udf
Cheers
Tim...
On Mon, May 19, 2014 at 3:28 PM, McPeak, Matt <vxsmimmcp_at_subaru.com> wrote:
> Hi. I’m a bit lazy on this one – looked for 15 minutes and didn’t
> find anything and it’s sort of just a passing question in my mind
> anyway. But I thought I’d throw it out to the group…
>
>
>
> So, 12c has a new feature that allows you to declare PL/SQL functions
> in-line in SQL with a “WITH” clause. In addition to not requiring
> privileges to create packages, these PL/SQL functions are executed
> without a context switch from SQL to PL/SQL, and so are perform better
> than calls to stored PL/SQL. (Stop me right there if any of that’s
> not correct)
>
>
>
> My question is: if an in-line PL/SQL function calls a stored PL/SQL
> function, does it all still execute without a context switch?
>
>
>
> Thanks in advance for your help!
>
>
>
> Matt
>
>
i0zX+ n{+i^
Received on Mon May 19 2014 - 17:13:08 CEST