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
- https://technology.amis.nl/2012/04/11/generating-a-pdf-document-with-some-plsql-as_pdf_mini-as_pdf3/
- https://technology.amis.nl/blog/8650/as_pdf-generating-a-pdf-document-with-some-plsql
- https://www.erasme.org/PL-FPDF,1337?lang=en
- https://ora-00001.blogspot.com/2009/10/free-pdf-package-for-plsql.html
- https://sourceforge.net/projects/pljrxml2pdf/
- https://www.plpdf.com/
- PDF_BUILDER_PKG
- PDFGEN_PKG
##Generate Excel files using PL/SQL
- https://technology.amis.nl/blog/10995/create-an-excel-file-with-plsql
- https://www.jasonsdevelopercorner.com/?page_id=8
- https://xml-spreadsheet.samplecode.oracle.com/
- https://sanjeev-oracle-world.blogspot.com/2007/06/create-excel-workbook-by-plsql-code.html
- https://matzberger.de/oracle/spreadsheet-en.html
- https://www.protalk.in/oracle/plsql-tips-package-for-exporting-data-to-excel/
- XLSX_BUILDER_PKG
- SYLK_UTIL_PKG
##Generate RTF files using PL/SQL
##Working with Office 2007 (OOXML) files using PL/SQL
- https://ora-00001.blogspot.com/2011/02/working-with-office-2007-ooxml-files.html
- https://technology.amis.nl/blog/8090/parsing-a-microsoft-word-docx-and-unzip-zipfiles-with-plsql
- https://www.docufy.be/
- OOXML_UTIL_PKG
##Zip and unzip files using PL/SQL
##Generate and parse CSV files using PL/SQL
##Generate and parse RSS feeds using PL/SQL
- https://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-one.html
- https://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-two.html
- RSS_UTIL_PKG
##Generate JSON using PL/SQL
##Parse JSON using PL/SQL
- https://github.com/pljson/pljson
- https://reseau.erasme.org/pl-sql-library-for-JSON?lang=en
##Transfer files (FTP) using PL/SQL
##Send email (SMTP) using PL/SQL
- https://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html
- https://download.oracle.com/docs/cd/E10513_01/doc/apirefs.310/e12855/apex_mail.htm
- MAIL_UTIL_PKG
##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
- https://ora-00001.blogspot.com/2009/12/using-google-translate-from-plsql.html
- GOOGLE_AUTH_PKG
- GOOGLE_CALENDAR_PKG
- GOOGLE_MAPS_PKG
- GOOGLE_TRANSLATE_PKG
##Integrate with Amazon web services (Simple Storage Service S3) using PL/SQL
- https://ora-00001.blogspot.com/2011/03/amazon-s3-api-for-plsql.html
- https://jastraub.blogspot.com/2011/01/building-amazon-s3-client-with.html
- AMAZON_AWS_AUTH_PKG
- AMAZON_AWS_S3_PKG
##Integrate with PayPal web services
- PAYPAL_UTIL_PKG
##Integrate with Twitter using PL/SQL
##Call SOAP and REST web services using PL/SQL
- https://jastraub.blogspot.com/2008/06/flexible-web-service-api.html
- https://flex-ws-api.samplecode.oracle.com/
- https://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/apex_web_service.htm#BABFFDEH
- https://ora-00001.blogspot.com/2009/07/calling-soap-web-service-from-plsql-by.html
- FLEX_WS_API
- SOAP_CLIENT_UTIL_PKG
- T_SOAP_ENVELOPE
##Publish SOAP web service using PL/SQL
- https://ora-00001.blogspot.com/2011/01/soap-server-in-plsql.html
- SOAP_SERVER_PKG
##Publish REST web services using PL/SQL
- https://ora-00001.blogspot.com/2009/07/creating-rest-web-service-with-plsql.html
- https://www.oracle-base.com/articles/misc/XMLOverHTTP.php
##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
- https://ora-00001.blogspot.com/2011/02/display-any-xml-as-clickable-tree-using.html
- XML_BUILDER_PKG
- XML_DATASET_PKG
- XML_STYLESHEET_PKG
- XML_UTIL_PKG
##File utilities
- FILE_UTIL_PKG
##HTTP utilities
- HTTP_UTIL_PKG
##Encryption and security utilities and protocols
- https://ora-00001.blogspot.com/2011/08/ntlm-for-plsql.html
- CRYPTO_UTIL_PKG
- NTLM_UTIL_PKG
- NTLM_HTTP_PKG
##Logging and debugging utilities
- https://github.com/tmuth/Logger---A-PL-SQL-Logging-Utility
- https://sourceforge.net/projects/log4plsql/
- https://sourceforge.net/projects/ilo/
- DEBUG_PKG
##Generating test data and random bits using PL/SQL
##PL/SQL Web Toolkit (OWA) utilities
- OWA_UTIL_PKG
##Web Gateways for PL/SQL
- https://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_epg.htm
- https://download.oracle.com/docs/cd/B14099_19/web.1012/b14010/toc.htm
- https://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html
- https://code.google.com/p/thoth-gateway/
- https://sourceforge.net/projects/dbprism/
- https://oss.oracle.com/projects/mod_owa/dist/documentation/modowa.htm
##jQGrid Integration Kit for PL/SQL and Apex
- https://ora-00001.blogspot.com/2010/03/jqgrid-integration-kit-for-plsql-and.html
- https://code.google.com/p/jqgrid-for-plsql/
##Application Express APIs
##Miscellaneous utilities and demos
- https://www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip
- https://www.toadworld.com/platforms/oracle/w/wiki/8243.plsql-obsession
##PL/SQL Frameworks
- https://sourceforge.net/projects/plsqlframestart/
- https://www.toadworld.com/Freeware/PLVisionFreeware/tabid/687/Default.aspx
##PL/SQL Wrappers for Java
##Unit Testing Frameworks for PL/SQL
##Documentation Generators (JavaDoc-style)
- https://sourceforge.net/projects/plsqlutils/
- https://www.thatjeffsmith.com/archive/2012/03/javadoc-for-the-database-a-la-dbdoc-via-sql-developer/
##Scripting, deployment and installation utilities