O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Using Advanced Interface Methods

External routines enable the communication between the Oracle database and the programs, which are written in non-database language such as C, C++, Java, or COBOL. The fact is not new that Oracle has emerged as a compatible database manager for application clients. But from the programming and development perspective, every language has its own special features and utilities. Before UTL_MAIL and UTL_SMTP came to the rescue, there was no option for sending an e-mail in Oracle. In some situations, a special logic written on the client side is required to be used on the server side too. The idea is to resolve the situations where a non-PL/SQL program has to be invoked from PL/SQL. To confront such situations, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required