plsql-utils

Oracle PL/SQL Utility Library, codename "Alexandria"

IMPORTANT NOTE

THIS PROJECT HAS NOW MOVED TO GITHUB

https://github.com/mortenbra/alexandria-plsql-utils

PLEASE GO TO THE GITHUB LINK ABOVE FOR LATEST UPDATES

http://plsql-utils.googlecode.com/files/alexandria-logo.jpg

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

http://upload.wikimedia.org/wikipedia/commons/thumb/1/1b/X-office-document.svg/48px-X-office-document.svg.png' align='right' />http://upload.wikimedia.org/wikipedia/commons/thumb/0/07/X-office-presentation.svg/48px-X-office-presentation.svg.png' align='right' />http://upload.wikimedia.org/wikipedia/commons/thumb/f/f8/X-office-spreadsheet.svg/48px-X-office-spreadsheet.svg.png' align='right' />

  • http://ora-00001.blogspot.com/2011/02/working-with-office-2007-ooxml-files.html
  • http://technology.amis.nl/blog/8090/parsing-a-microsoft-word-docx-and-unzip-zipfiles-with-plsql
  • http://www.docufy.be/
  • OOXML_UTIL_PKG

Zip and unzip files using PL/SQL

http://upload.wikimedia.org/wikipedia/commons/thumb/9/9c/The_Unarchiver_zip.png/64px-The_Unarchiver_zip.png' align='right' />

  • http://technology.amis.nl/blog/7626/utl_compress-gzip-and-zlib
  • ZIP_UTIL_PKG

Generate and parse CSV files using PL/SQL

http://upload.wikimedia.org/wikipedia/commons/thumb/3/38/CsvDelimited001.svg/113px-CsvDelimited001.svg.png' align='right' />

  • http://ora-00001.blogspot.com/2010/04/select-from-spreadsheet-or-how-to-parse.html
  • CSV_UTIL_PKG

Generate and parse RSS feeds using PL/SQL

http://upload.wikimedia.org/wikipedia/commons/thumb/4/43/Feed-icon.svg/75px-Feed-icon.svg.png' align='right' />

  • http://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-one.html
  • http://ora-00001.blogspot.com/2011/02/fun-with-rss-and-plsql-part-two.html
  • RSS_UTIL_PKG

Generate JSON using PL/SQL

  • http://ora-00001.blogspot.com/2010/02/ref-cursor-to-json.html
  • JSON_UTIL_PKG

Parse JSON using PL/SQL

  • http://sourceforge.net/projects/pljson/
  • http://reseau.erasme.org/pl-sql-library-for-JSON?lang=en

Transfer files (FTP) using PL/SQL

  • http://www.oracle-base.com/articles/misc/FTPFromPLSQL.php
  • FTP_UTIL_PKG

Send email (SMTP) using PL/SQL

http://upload.wikimedia.org/wikipedia/commons/thumb/b/b1/Arobaze.svg/75px-Arobaze.svg.png' align='right' />

  • http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html
  • http://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)

  • http://plsqlmailclient.sourceforge.net/

Work with MS Exchange using PL/SQL

  • http://ora-00001.blogspot.com/2012/05/ms-exchange-api-for-plsql.html
  • MS_EWS_UTIL_PKG

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

http://upload.wikimedia.org/wikipedia/commons/thumb/3/30/Googlelogo.png/200px-Googlelogo.png' align='right' />

  • http://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

http://upload.wikimedia.org/wikipedia/en/thumb/1/1d/AmazonWebservices_Logo.svg/250px-AmazonWebservices_Logo.svg.png' align='right' />

  • http://ora-00001.blogspot.com/2011/03/amazon-s3-api-for-plsql.html
  • http://jastraub.blogspot.com/2011/01/building-amazon-s3-client-with.html
  • AMAZON_AWS_AUTH_PKG
  • AMAZON_AWS_S3_PKG

Integrate with PayPal web services

http://upload.wikimedia.org/wikipedia/commons/thumb/3/39/PayPal_logo.svg/200px-PayPal_logo.svg.png' align='right' />

  • PAYPAL_UTIL_PKG

Integrate with Twitter using PL/SQL

http://upload.wikimedia.org/wikipedia/en/9/9f/Twitter_bird_logo_2012.svg' align='right' width='100' />

  • http://oratweet.com/

Call SOAP and REST web services using PL/SQL

  • http://jastraub.blogspot.com/2008/06/flexible-web-service-api.html
  • https://flex-ws-api.samplecode.oracle.com/
  • http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/apex_web_service.htm#BABFFDEH
  • http://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

http://upload.wikimedia.org/wikipedia/commons/thumb/5/59/SOAP.svg/182px-SOAP.svg.png' align='right' />

  • http://ora-00001.blogspot.com/2011/01/soap-server-in-plsql.html
  • SOAP_SERVER_PKG

Publish REST web services using PL/SQL

  • http://ora-00001.blogspot.com/2009/07/creating-rest-web-service-with-plsql.html
  • http://www.oracle-base.com/articles/misc/XMLOverHTTP.php

Regular expressions using PL/SQL

http://upload.wikimedia.org/math/2/a/8/2a8ea57cab60c6ac9279fbf68e37ba0d.png' align='right' />

  • 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

http://upload.wikimedia.org/wikipedia/commons/thumb/a/aa/SQL_ANATOMY_wiki.svg/275px-SQL_ANATOMY_wiki.svg.png' align='right' />

  • SQL_BUILDER_PKG
  • SQL_UTIL_PKG

XML utilities

http://upload.wikimedia.org/wikipedia/commons/thumb/6/68/XML.svg/125px-XML.svg.png' align='right' />

  • http://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

  • http://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
  • http://sourceforge.net/projects/log4plsql/
  • http://sourceforge.net/projects/ilo/
  • DEBUG_PKG

Generating test data and random bits using PL/SQL

  • http://ora-00001.blogspot.com/2011/02/generating-test-data-using-plsql.html
  • RANDOM_UTIL_PKG

PL/SQL Web Toolkit (OWA) utilities

  • OWA_UTIL_PKG

Web Gateways for PL/SQL

  • http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_epg.htm
  • http://download.oracle.com/docs/cd/B14099_19/web.1012/b14010/toc.htm
  • http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html
  • http://code.google.com/p/thoth-gateway/
  • http://sourceforge.net/projects/dbprism/
  • http://oss.oracle.com/projects/mod_owa/dist/documentation/modowa.htm

jQGrid Integration Kit for PL/SQL and Apex

  • http://ora-00001.blogspot.com/2010/03/jqgrid-integration-kit-for-plsql-and.html
  • http://code.google.com/p/jqgrid-for-plsql/

Application Express APIs

  • http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/toc.htm
  • APEX_UTIL_PKG

Miscellaneous utilities and demos

  • http://www.toadworld.com/Portals/0/stevenf/demo.zip
  • http://www.toadworld.com/ORACLE/StevenFeuersteinsPLSQLObsession/tabid/153/Default.aspx

PL/SQL Frameworks

  • http://sourceforge.net/projects/plsqlframestart/
  • http://www.toadworld.com/Freeware/PLVisionFreeware/tabid/687/Default.aspx

PL/SQL Wrappers for Java

  • http://sourceforge.net/projects/oracle-jutils/

Unit Testing Frameworks for PL/SQL

  • http://sourceforge.net/projects/utplsql/
  • http://code.google.com/p/pluto-test-framework/

Documentation Generators (JavaDoc-style)

  • http://sourceforge.net/projects/plsqlutils/
  • http://www.thatjeffsmith.com/archive/2012/03/javadoc-for-the-database-a-la-dbdoc-via-sql-developer/

Scripting, deployment and installation utilities

  • http://code.google.com/p/oracle-ddl2svn/'>http://code.google.com/p/oracle-ddl2svn/

    •

    Project Information

    Labels:
    plsql ntlm Database oracle json pdf excel zip xml soap rss amazon ftp smtp ooxml