This is a set of PLSQL packages for the Oracle database which provide acess 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.
Release Date:
Topic:
License:
Intended Audience:
User Interface:
Database Environment:
Programming Language:
Registered:
Ratings and Reviews
Be the first to post a text review of Oracle PL/SQL executing OS Commands. Rate and review a project by clicking thumbs up or thumbs down in the right column.
Project Feed
-
File released: /plsqlexecoscomm/0.6.2/ReleaseNotes_0.6.2.txt
-
File released: /plsqlexecoscomm/0.6.2/PLSQL_OSCOMMAND_0.6.2.tar.gz
-
File released: /plsqlexecoscomm/0.6.2/PLSQL_OSCOMMAND_0.6.2.zip
-
plsqlexecoscomm 0.6.1 file released: PLSQL_OSCOMMAND_0.6.1.zip
* Version (last entry indicates must current version): * 0.1 (2008/01/14) * - initial version * 0.2 (2008/01/18) * - added various overloaded functions to get also the return * codes from the OS call * - enhanced the function GET_FILE_LIST; now it returns additional * file attributes and not just the file name * - moved the WRITE_BLOB_TO_FILE procedure into an own package * - added a procedure WRITE_CLOB to the new package * 0.5 (2008/03/09) * - completely reorganized code into separate java classes * and PL/SQL packages * + FILE_TYPE: Object type for file operations * + FILE_PKG: PL/SQL package with accessor methods for the file system * + OS_COMMAND: PL/SQL package for executing shell commands * + LOB_WRITER_PLSQL: PL/SQL package for writing LOBs to files using * UTL_FILE * 0.6 (2008/11/10) * - added support for environment variables in OS_COMMAND * - added support for defining a "working dir" in OS_COMMAND * - changed auth model of FILE_TYPE to invoker's rights (authid CURRENT_USER) * - FILE_TYPE no longer requires Java WRITE privileges to read a file * - added methods for retrieving root directories to FILE_PKG * - added method for retrieving the path separator char to FILE_PKG * - added get_parent method to FILE_TYPE * 0.6.1 (2008/12/15) * - fixed bug: directory listing (FILE_PKG.GET_FILE_LIST) now works also with * non readable files in the directory. AccessControlException * is no longer thrown *
-
plsqlexecoscomm 0.6.1 file released: PLSQL_OSCOMMAND_0.6.1.zip
* Version (last entry indicates must current version): * 0.1 (2008/01/14) * - initial version * 0.2 (2008/01/18) * - added various overloaded functions to get also the return * codes from the OS call * - enhanced the function GET_FILE_LIST; now it returns additional * file attributes and not just the file name * - moved the WRITE_BLOB_TO_FILE procedure into an own package * - added a procedure WRITE_CLOB to the new package * 0.5 (2008/03/09) * - completely reorganized code into separate java classes * and PL/SQL packages * + FILE_TYPE: Object type for file operations * + FILE_PKG: PL/SQL package with accessor methods for the file system * + OS_COMMAND: PL/SQL package for executing shell commands * + LOB_WRITER_PLSQL: PL/SQL package for writing LOBs to files using * UTL_FILE * 0.6 (2008/11/10) * - added support for environment variables in OS_COMMAND * - added support for defining a "working dir" in OS_COMMAND * - changed auth model of FILE_TYPE to invoker's rights (authid CURRENT_USER) * - FILE_TYPE no longer requires Java WRITE privileges to read a file * - added methods for retrieving root directories to FILE_PKG * - added method for retrieving the path separator char to FILE_PKG * - added get_parent method to FILE_TYPE * 0.6.1 (2008/12/15) * - fixed bug: directory listing (FILE_PKG.GET_FILE_LIST) now works also with * non readable files in the directory. AccessControlException * is no longer thrown *
-
plsqlexecoscomm 0.6.1 file released: PLSQL_OSCOMMAND_0.6.1.tar.gz
* Version (last entry indicates must current version): * 0.1 (2008/01/14) * - initial version * 0.2 (2008/01/18) * - added various overloaded functions to get also the return * codes from the OS call * - enhanced the function GET_FILE_LIST; now it returns additional * file attributes and not just the file name * - moved the WRITE_BLOB_TO_FILE procedure into an own package * - added a procedure WRITE_CLOB to the new package * 0.5 (2008/03/09) * - completely reorganized code into separate java classes * and PL/SQL packages * + FILE_TYPE: Object type for file operations * + FILE_PKG: PL/SQL package with accessor methods for the file system * + OS_COMMAND: PL/SQL package for executing shell commands * + LOB_WRITER_PLSQL: PL/SQL package for writing LOBs to files using * UTL_FILE * 0.6 (2008/11/10) * - added support for environment variables in OS_COMMAND * - added support for defining a "working dir" in OS_COMMAND * - changed auth model of FILE_TYPE to invoker's rights (authid CURRENT_USER) * - FILE_TYPE no longer requires Java WRITE privileges to read a file * - added methods for retrieving root directories to FILE_PKG * - added method for retrieving the path separator char to FILE_PKG * - added get_parent method to FILE_TYPE * 0.6.1 (2008/12/15) * - fixed bug: directory listing (FILE_PKG.GET_FILE_LIST) now works also with * non readable files in the directory. AccessControlException * is no longer thrown *
-
plsqlexecoscomm 0.6.1 file released: PLSQL_OSCOMMAND_0.6.1.tar.gz
* Version (last entry indicates must current version): * 0.1 (2008/01/14) * - initial version * 0.2 (2008/01/18) * - added various overloaded functions to get also the return * codes from the OS call * - enhanced the function GET_FILE_LIST; now it returns additional * file attributes and not just the file name * - moved the WRITE_BLOB_TO_FILE procedure into an own package * - added a procedure WRITE_CLOB to the new package * 0.5 (2008/03/09) * - completely reorganized code into separate java classes * and PL/SQL packages * + FILE_TYPE: Object type for file operations * + FILE_PKG: PL/SQL package with accessor methods for the file system * + OS_COMMAND: PL/SQL package for executing shell commands * + LOB_WRITER_PLSQL: PL/SQL package for writing LOBs to files using * UTL_FILE * 0.6 (2008/11/10) * - added support for environment variables in OS_COMMAND * - added support for defining a "working dir" in OS_COMMAND * - changed auth model of FILE_TYPE to invoker's rights (authid CURRENT_USER) * - FILE_TYPE no longer requires Java WRITE privileges to read a file * - added methods for retrieving root directories to FILE_PKG * - added method for retrieving the path separator char to FILE_PKG * - added get_parent method to FILE_TYPE * 0.6.1 (2008/12/15) * - fixed bug: directory listing (FILE_PKG.GET_FILE_LIST) now works also with * non readable files in the directory. AccessControlException * is no longer thrown *
-
File released: /plsqlexecoscomm/0.6.1/PLSQL_OSCOMMAND_0.6.1.tar.gz
-
File released: /plsqlexecoscomm/0.6.1/PLSQL_OSCOMMAND_0.6.1.zip
-
Oracle PL/SQL executing OS Commands: Version 0.6 released
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.
Rate and Review
Be the first person to add a text review.
Related Projects
-
Mail Client API for Oracle PL/SQL
In the Oracle database there are two PL/SQL APIs to send mails: UTL_SMTP and UTL_MAIL. But there is no package which is able to retrieve messages from a mailbox on a server. The here provided package MAIL_CLIENT closes this gap.
-
plsql-hashtable
PLSQL-Hashtable is a hashtable implementation written in PL/SQL using object syntax. The hashtable is generic, but can be specialized in order to gain speed. Object types can be stored in the oracle database, persistently.
-
Oracle PL/SQL executing OS Commands Actions
About SourceForge
Develop Software
Community
Copyright © 2010 Geeknet, Inc. All rights reserved. Terms of Use
