As mentioned in my earlier post
, I've been working on a PL/SQL wrapper for the Microsoft Exchange Web Services (EWS) API. The code is now ready for an initial release!
Using this pure PL/SQL package, you will be able not just to search for and retrieve emails and download attachments, but you will also be able to create emails and upload attachments to existing emails. You can move emails between folders, and delete emails. You can read and create calendar items. You can get the email addresses of the people in a distribution (mailing) list, and more.
"It is sayd, that at the nede the frende is knowen."
- William Caxton: "Sonnes of Aymon" (1489)
"I say, that when you screw up, Flashback Query is a friend indeed!"
- Morten Braten: "SQLs of Oracle" (2012)
The Flashback Query
feature of Oracle (10g) can be really helpful when you run that UPDATE or DELETE statement and then, after
the COMMIT, you discover that you made a mistake!
Wouldn't it be nice to be able to look back and see what the data looked like before you messed things up? With a Flashback Query you (more...)
It's been over two years since I released the initial version
of the jQGrid Integration Kit for PL/SQL and Apex.
Since then, I've added some additional features and fixed a few bugs:
- Procedure include_static_files_once will make sure required JS and CSS files are correctly included
- Support for "popup_lov" column edit type
- Procedure render_grid supports p_read_only parameter that can be used to set read-only dynamically
- Support for some jQGrid built-in formatters based on Oracle column data type
- Lists of values (select list variety, not Popup LOV) now support bind variables and Static LOVs
- Date parser handles dates and (more...)
... or how to read your (Microsoft Exchange) email using SQL and PL/SQL.
You are probably familiar with sending
email using PL/SQL; there's the UTL_SMTP package, the APEX_MAIL package, and various other utilities that do this.
But what about reading
email using PL/SQL? You need to investigate the POP and IMAP protocols. A quick search on Google turns up some sample code
and even a feature-rich package
, although the latter requires Java in the database (which I try to avoid whenever possible, and which is not available in Oracle XE in any case).
Approaching this from a different angle, (more...)
Here's a bunch of interesting stuff related to PL/SQL and Apex that I've come across lately, I'm posting it both as a reminder to myself, and to help spread the word:
- First mention of PL/SQL enhancements for Oracle Database 12c: In his PL/SQL newsletter for March 2012, Steven Feuerstein revealed that "I've also started beta testing Oracle Database 12c PL/SQL. I can't yet share with you any of the new features, but I can tell you that PL/SQL will certainly be a richer, more usable language when 12c goes production!".
- On that topic, a couple of things I (more...)