ORA-00001: Unique constraint violated

Slack is a web-based chat room popular with many companies. Slack also has an API that can be used to post messages to a given "channe...

Do you need to accept payments for goods and services via your (APEX) application and would you prefer to handle the payments in the databas...

Today's post is about a new plugin that I developed for Oracle Application Express (Apex). The plugin was inspired by a product call...

Do you need to send SMS (Short Message Service) text messages from your Oracle database using PL/SQL? This is actually quite easy to do, the...

The PL/SQL Utility Library, codenamed "Alexandria", now has a new home at GitHub . This will make it easier to collaborate on the ...

The latest version of Alexandria, the utility library for PL/SQL , is now available for download . The previous version has been downloaded ...

In my last blog post I described using the DBMS_DATAPUMP and DBMS_JOB packages to automate database schema backups from the database itself...

Usually, database backups are the responsibility of DBAs, and not something that developers really care or think too much about. However, if...

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 n...

... or how to read your (Microsoft Exchange) email using SQL and PL/SQL. Introduction You are probably familiar with sending email usi...

NTLM , or more properly NTLMSSP is a protocol used on Microsoft Windows system as part of the so-called Integrated Windows Authentication ....

I've just uploaded a new version of the Alexandria Utility Library for PL/SQL . Updates include both small bug fixes and some major n...

Amazon S3 is part of Amazon's Web Service offering and the name is an abbreviation for Simple Storage Service : "Amazon S3 provi...