Tuesday, January 18, 2011

PL/SQL Utility Library

Most programmers have a collection of utilities and code libraries that they re-use for several projects.

I've created the PL/SQL Utility Library page on Google Code to host some generic utilities that I've written myself, some that I've collected from elsewhere (credits and links can be found in the relevant source code), as well as links to useful PL/SQL libraries that are actively maintained elsewhere.

Check out the links and download the source code, there's a lot of different stuff here; from parsing CSV files, integrating with Google Maps and generating JSON, to zipping/unzipping files with PL/SQL.

I plan to add several more packages as soon as I get the code cleaned up.

Drop a comment below if you know of any other PL/SQL libraries or utilities that should be added to the list!


mnolan said...

Hi Morten

Thats a pretty comprehensive and awesome list of stuff, thanks for putting it all together and making it available.

You're a legend!


David said...


The list looks impressive, but it seems that there are files missing from the download file. Of the files mentioned on the front page, I'm not seeing PDFGEN/PDFGEN_UTIL, RSS_UTIL, MAIL_UTIL, POP3_UTIL, GOOGLE_AUTH, GOOGLE_CALENDAR, AMAZON_AWS, PAYPAL_UTIL, SOAP_CLIENT_UTIL, STRING_UTIL, DATE_UTIL, SQL_UTIL, XML_UTIL, or XML_DATASET...

Morten Braten said...

@David: That's right, as mentioned in my post I plan to add several more packages as soon as they are ready. Consider the list a preview of things to come...

- Morten

Pedro Leite said...

awesome job :)

Johannes said...

Thanks Morten

Anonymous said...

Great library! But I have a complaint :). Unzipping with ZIP_UTIL_PKG doesn't work on Oracle 11.2 database. But I fixed it, see http://forums.oracle.com/forums/thread.jspa?messageID=9289744#9289744

By the way, I'm working on Yet Another Excel Package, almost finished.

Morten Braten said...

@Anton: Thanks, I hope you don't mind me including your awesome code in my library. I've just uploaded a new version of the library, where I included the updated version of your zip package.

I noticed you had some Excel generation code in one of your Apex plugins, looking forward to see it as a stand-alone package!

- Morten

blogje said...

The Excel stand-alone is available at this place: http://technology.amis.nl/blog/?p=10995