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_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, ...