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!
8 comments:
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!
Cheers
Matt
Morten,
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...
@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
NICE!
awesome job :)
Thanks Morten
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
Anton
By the way, I'm working on Yet Another Excel Package, almost finished.
@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
The Excel stand-alone is available at this place: http://technology.amis.nl/blog/?p=10995
Post a Comment