Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can PRAGMA UDF be used in functions inside a package?

PLSQL_GUYMar 27 2017 — edited Mar 27 2017

Will PRAGMA UDF give a performance boost only for standalone functions??

How about functions defined inside packages?? 

If we create a function inside a package with PRAGMA UDF specified and

then call it inside an SQL in another procedure inside the same function

will it give the performance improvement?

Source: Steven Feuerstein on Oracle PL/SQL

https://docs.oracle.com/database/121/LNPLS/udf_pragma.htm#LNPLS1851

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2017
Added on Mar 27 2017
5 comments
1,810 views