Search Results for "utility"

A set of utilities and libraries, enhancing standard system PL/SQL packages in the Oracle Database. Attention!!! we moved to GitHub: https://github.com/oramake/oramake-framework Includes: - a utility for creating, developing and documenting program modules in Oracle DB; - a utility for watching the DB size and tracing Oracle sessions ( put pkg_ProcessMonitor.setSqlTrace() before your code and you then receive an email with 10046 events trace file); - logging feature ( similar to log4j, extending limit of PL/SQL Exception message length to 32K); - easy working with files; - flexibly customized scheduler ( similar to cron); - creating Microsoft Excel xml-files; - sending and receiving email messages ( implementation of smtp and pop3 protocols); - a PL/SQL interface for jdbc access ( existing libraries for accessing MS Sql Server, Sybase, DB2 from Oracle DB); - an interface for accessing Subversion; - a utility for parsing CSV and other text files.

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). ...