Oracle Database 12c enables enhanced security for extproc by authenticating it against a user-supplied credential. This new feature allows the creation of a user credential and links it with a PL/SQL library object. Whenever an application calls an external procedure, the extproc process authenticates the connection before loading the shared library. The DBMS_CREDENTIAL package is… Read More #DB12c feature – Secure External Procedures with DBMS_CREDENTIAL
Hi All, Last week, I registered my presence at Collaborate’15 in Las Vegas as a speaker, attendee and at Oracle demo booth duty. It was an awesome experience meeting some polished brains and smart minds. After the first day of registration, I attended the #DBIM12c session by Maria Colgan, #DB12c Multitenant by John McHugh and #Exadata session… Read More #C15LV Collaborate’15 updates!!
Here are two interesting enhancements in Oracle database 12c PL/SQL. PL/SQL subprogram defined using WITH clause of a subquery – Oracle database 12c allows PL/SQL declaration section in the WITH clause. One can define PL/SQL function or procedure into a WITH clause. Functions declared in the PL/SQL declaration section can be invoked instantly in the… Read More Oracle Database 12c PRAGMA UDF and WITH clause enhancements
Saurabh is the author of our recently published Oracle Advanced PL/SQL Developer Professional Guide Which helps master the advanced features of PL/SQL to design and optimize code using real-time demonstrations. Find the complete interview at the below link http://authors.packtpub.com/content/interview-saurabh-k-gupta-author-oracle-advanced-plsql-developer-professional-guide