Oracle PL/SQL executing OS Commands / News: Recent posts

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.