Very cool. I will have to read up on that pragma. Thanks! Matt -----Original Message----- From: timseanhall@xxxxxxxxx [mailto:timseanhall@xxxxxxxxx] On Behalf Of Tim Hall Sent: Monday, May 19, 2014 10:53 AM To: McPeak, Matt Cc: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxx> 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 > >