/alexandria-plsql-utils

Oracle PL/SQL Utility Library

Primary LanguagePLSQL

alexandria-plsql-utils

Oracle PL/SQL Utility Library

This library is a collection of various utility packages for PL/SQL, as well as links to useful libraries hosted and maintained elsewhere.

Generate PDF files using PL/SQL

Generate Excel files using PL/SQL

Generate RTF files using PL/SQL

Working with Office 2007 (OOXML) files using PL/SQL


Zip and unzip files using PL/SQL


Generate and parse CSV files using PL/SQL


Generate and parse RSS feeds using PL/SQL


Generate JSON using PL/SQL

Parse JSON using PL/SQL

Transfer files (FTP) using PL/SQL

Send email (SMTP) using PL/SQL


Receive email (POP3) using PL/SQL

  • POP3_UTIL_PKG

Receive email (POP3 and IMAP) using PL/SQL (and Java)

##Work with MS Exchange using PL/SQL

Integrate with Google services (Google Maps, Google Calendar, Google Translate) using PL/SQL


Integrate with Amazon web services (Simple Storage Service S3) using PL/SQL


Integrate with PayPal web services


  • PAYPAL_UTIL_PKG

Integrate with Twitter using PL/SQL


Call SOAP and REST web services using PL/SQL

Publish SOAP web service using PL/SQL


Publish REST web services using PL/SQL

Regular expressions using PL/SQL


  • REGEXP_UTIL_PKG

String, date and math utilities

  • DATE_UTIL_PKG
  • MATH_UTIL_PKG
  • STRING_UTIL_PKG

Encoding and data type utilities

  • ENCODE_UTIL_PKG
  • RAW_UTIL_PKG

SQL utilities


  • SQL_BUILDER_PKG
  • SQL_UTIL_PKG

XML utilities


File utilities

  • FILE_UTIL_PKG

HTTP utilities

  • HTTP_UTIL_PKG

Encryption and security utilities and protocols

Logging and debugging utilities

Generating test data and random bits using PL/SQL

PL/SQL Web Toolkit (OWA) utilities

  • OWA_UTIL_PKG

Web Gateways for PL/SQL

jQGrid Integration Kit for PL/SQL and Apex

Application Express APIs

Miscellaneous utilities and demos

PL/SQL Frameworks

PL/SQL Wrappers for Java

Unit Testing Frameworks for PL/SQL

Documentation Generators (JavaDoc-style)

Scripting, deployment and installation utilities