Open-source PL/SQL

 
Internet, web, xml, and the like
ExcelDocumentType Create formatted Microsoft Excel documents in Excel XML
Home
http://radio.weblogs.com/0137094/2006/10/26.html
Download
http://radio.weblogs.com/0137094/files/PLSQLExcelObject.zip
Minimum Oracle Version
unknown
 
JSON Library Tools for generating JSON (JavaScript Object Notation) from PL/SQL .
Home
http://www.erasme.org/Librairie-JSON
Download
http://www.erasme.org/IMG/zip/json-0.1-2.zip
Minimum Oracle Version
unknown
 
CodeBrew A framework for PL/SQL Gateway (mod_plsql) developers.
Home
http://sourceforge.net/projects/plcodebrew/
Download
http://sourceforge.net/project/showfiles.php?group_id=60431
Minimum Oracle Version
9.2.0
 
FTP PL/SQL implementation of an FTP client
Home
http://www.myoracleportal.com/News/article/sid=93.html
Download
http://www.myoracleportal.com/Downloads/d_op=getit/lid=23.html
Minimum Oracle version
9.2.0
data structures
str String manipulations: split strings, turn them into tables, check to see if they are mixed case, a number, a date or an ordinal and toggle case in various combinations
Home
http://www.joegarrepy.com/str_package.htm
Download
http://www.joegarrepy.com/str_package.htm
Known dependencies
None
Minimum Oracle Version
Unknown
 
List Parsing and manipulation of arbitrarily delimited lists, including conversion to and from PL/SQL tables.
Home
http://www.smdi.com/employee/johnf/orastuff.htm
Download
http://www.smdi.com/employee/johnf/listcrpa.sql
Known dependencies
None
Minimum Oracle Version
8.1.7
security, encryption, and checksum utilities
MD5 Implementation of the one-way encryption used in RSA cryptography products.
Home
http://cellar.sourceforge.net/plsql/
Download
http://cellar.sourceforge.net/plsql/fast_md5.txt
Known dependencies
bw (bitwise operations) package
 
RC4 Implementation of a "fast" stream cipher for encryption and decryption.
Home
http://www.cybcon.com/~jkstill/util/encryption/encryption.html
Download
http://www.cybcon.com/~jkstill/util/zips/rc4_plsql.tar.gz
Known dependencies
None
 
verify_user Function to determine whether given username, password is correct.
Home
http://plnet.org/files/verify_user.sql
Download
http://plnet.org/files/verify_user.sql
Known dependencies
Requires presence of SQL*Net on same server
Minimum Oracle version
8.1.6
developer's suites
PLVision Lite Miscellaneous developer utilities and packages, originally published with Advanced Oracle PL/SQL Programming with Packages.
Home
http://www.quest-pipelines.com/pipelines/plsql/archives.htm#misc04
Download
http://www.quest-pipelines.com/pipelines/plsql/archives/plvlzip.zip
Known dependencies
None
 
utPLSQL Unit-testing framework based on the principles of "extreme programming."
Home
http://utplsql.sourceforge.net
Download
https://sourceforge.net/project/showfiles.php?group_id=6633
Known dependencies
None
code management
PLDoc Javadoc-like tool for PL/SQL
Home
http://sourceforge.net/projects/pldoc
Download
http://sourceforge.net/project/showfiles.php?group_id=38875
Known dependencies
None
 
export_source Unload a user's stored PL/SQL for migration to another schema or database
Home
http://www.oracle.com/oramag/code/tips2000/112000.html
Download
http://www.oracle.com/oramag/code/tips2000/112000.html
Known dependencies
None
 
recompile Intelligently recompiles invalid PL/SQL program units.
Home
http://www.quest-pipelines.com/pipelines/plsql/archives.htm#code32
Download
http://www.quest-pipelines.com/pipelines/plsql/archives/syrecomp.zip
Known dependencies
None
 
get_extracts Recursively identify a single PL/SQL program's dependencies
Home
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:431933581821
Download
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:431933581821
Known dependencies
None
logging, debugging and tracing
Log 4 pl/sql Sophisticated logging tool inspired by the log4J project
Home
http://log4plsql.sourceforge.net/
Download
http://sourceforge.net/project/showfiles.php?group_id=51533
Known dependencies
None
 
who_called_me Discover who called the current procedure, or determine the name of the procedure that is currently executing
Home
http://govt.oracle.com/~tkyte/who_called_me/index.html
Download
http://govt.oracle.com/~tkyte/who_called_me/who.sql
Known dependencies
None
Messaging and groupware
mail_files A PL/SQL procedure for sending an email, with attachments, from the Oracle server.
Home
http://home.clara.net/dwotton/dba/oracle_smtp.htm
Download
http://home.clara.net/dwotton/dba/oracle_smtp.txt
Known dependencies
Requires Oracle JServer (installed as part of Oracle8i)
 
Mail Tools Send email with binary attachments (uses UTL_TCP, not UTL_SMTP)
Home
http://www.myoracleportal.com/News/article/sid=93.html
Download
http://www.myoracleportal.com/Downloads/d_op=getit/lid=24.html
Minimum Oracle version
9.2.0
 
DBLens An Oracle-based toolkit for performing collaborative filtering.
Home
http://dblens.sourceforge.net/
Download
http://sourceforge.net/project/showfiles.php?group_id=18155
Known dependencies
None
This page maintained by Bill Pribyl. Last updated 16-Jan-2008 10:45 PM .