|
|
 |
Sending mail from a PL/SQL program
|
| Total Hit (5777) |
You can send e-mail from a PL/SQL program using the built in UTL_SMTP package. It is written on top of UTL_TCP and implements the SMTP protocol for sending email. You can use it to communicate with an SMTP sever outside the database.
Please note that UTL_SMTP can be used only to send mail though
....Read More |
Rating
 |
|
|
|
Passing data between Functions and Procedures in Oracle.
|
| Total Hit (6735) |
In this code I've tried to show how data might be passed between functions and procedures in Oracle using cursor variables and collections.
I have made use of the example schema HR which is provided by Oracle.
The objective was to create a function that accepted a set of records passed to it a
....Read More |
Rating
 |
|
|
|