Open Source PL/SQL Frameworks

HIPAATalk - Contains stored procedures and sample DTS packages for parsing and converting X12 to flat tables and creating HIPAA-compliant X12 files. Currently reads 820, 834, 835, 837P/I/D, 841, 997, TA1, and creates 835, 837P/I/D, 834, 277U, 997, TA1.

Problem: How can Oracle PL/SQL applications read, write, move or copy arbitrarily large files to or from arbitrary file system locations? Solution: This utility (OFsX) uses PL/SQL, Oracle AQ & Spring Integration to handle reading, writing, copying, moving & deleting of files from Oracle PL/SQL in a general way. Summary: PL/SQL is an excellent language for developing data-intensive, enterprise applications. However, it can be difficult for PL/SQL applications to interact with a file system (Fs). OFsX makes two-way PL/SQL-to-Fs interaction easy.

This project is no longer supported. If you're looking for a table API generator for Oracle Database, checkout: https://github.com/osalvador/tapiGen2 tapiGen is a table API Generator for PL/SQL. It creates table encapsulation packages for tables that meet certain criteria. These TAPIs can reduce manual code creation while providing additional functionality for web based apps such as Oracle's ApEx.