dcsimg
Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


advertisement
 

Real-time Messaging in Oracle: Send E-mails Programmatically from the Database

Learn how you can send e-mails directly from an Oracle database as a real-time messaging solution. No longer will you need to wait for stored procedures to complete in order to monitor them.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


ecause Oracle does not provide a tool for outputting messages in real-time, Oracle database developers have always faced the challenge of monitoring their stored procedure execution in real-time. They've had to use the DBMS_OUTPUT.PUT_LINE call, which doesn't return the results of a procedure until the procedure has completed.

In this 10-Minute Solution, I will demonstrate how you can send e-mails directly from an Oracle8i database as a real-time messaging solution. Besides no longer needing to wait for stored procedures to complete in order to monitor them, such a feature offers the developer a few other benefits:

  • Debugging long batch processes in minutes rather than hours
  • Calculating the execution times for specified code blocks
  • Exporting selected data from the database and putting it in operating system (OS) text files, such as Excel spreadsheets.
  • Reviewing stored procedure information remotely.





How do I output messages from my running stored procedures so I can review them in real-time—even when I'm not in the office?



Group all necessary procedures and functions in your custom package and send e-mail directly from an Oracle database using the Oracle8i UTL_SMTP supplied package.


Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date