New Version contains support for different file system encodings, separate handling of STDOUT and STDERR and internal performance improvements - a simple folder listing is now faster by factor 2 to 5.
Check it out.
Version 0.9 released for testing +++ New pipelined functions GET_FILE_LIST (better performance) +++ "Complex" shell commands are now supported +++ SQL Developer extensions
This is a set of PLSQL packages for the Oracle database which provide access to the OS shell and the file system from SQL and PL/SQL. The packages provide operations on file handles (delete, create, move, copy) as well as the execution of shell commands.
Support for working directories,environment variables and operating system specific information added.
fixed two bugs which prevented code to be compiled in Oracle10g; documentation (generated with pldoc) added
new features for file operations (like copy, rename, write lob to, read lob from, create, mkdir, delete)
did some rearrange of functions and made the functionality to execute more complete
Version 0.1 is the initial version of the OS_COMMAND package. The project homepage (http://plsqlexecoscomm.sourceforge.net/) contains additional information, documentation and usage examples.