Open-source PL/SQL
- Learn about PLNet.org
- Submit your own code via email
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
. |
|||