About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 5 years ago
  • Total downloads: 478
  • Price: Free |
  • Operating system: Linux
  • Publisher: Carsten Czarski
See full specifications

linux default iconOracle PL/SQL executing OS Commands Publisher's description

PL/SQL executing shell (operating system) commands: OS_COMMAND and FILE_TYPE

Oracle PL/SQL executing OS Commands project contains the PL/SQL packages OS_COMMAND, FILE_TYPE and FILE_PKG which enable an Oracle database developer to interact with the operating system or with ordinary files. Oracle provides out-of-the-box only limited functionality for accessing the file system and no functionality to execute shell commands or operating system processes. There are PL/SQL scripts spread over the internet and in the Oracle forums but there is no ready-to-install package. This project is about to provide exactly this.

In general there are at least three ways to execute shell commands by the Oracle engine.

1. Coding a native shared library, reference it in the Oracle database using CREATE LIBRARY and create a PL/SQL wrapper on the particular functions. This required a C compiler for the platform Oracle is running on.
2. Using the Oracle-supplied package DBMS_SCHEDULER which is able to execute shell commands. But DBMS_SCHEDULER lacks access to STDIN and STDOUT; if this is needed, DBMS_SCHEDULER is not longer an option.
3. Since Oracle8i there is a J2SE compliant Java Engine contained in the database; as any other Java Engine it is capable to execute the shell commands via the System.exec method. The JDBC API allows to pass the contents of STDIN, STDOUT or the OS return values back to the SQL engine. And since Java is platform-independent one install script does the job for all platforms. So I took the decision for Java in the database.

The package runs in Oracle 10.1 or higher

What's New in This Release:

В· Separated files for Oracle10 and Oracle11g - the OS_COMMAND.LOAD_ENV methods are not available in 10g
В· Support for working directories when executing shell commands
В· Support for custom environment variables
В· FILE_TYPE no longer required write privileges when just reading files
В· PL/SQL package now works with invokers' rights
В· Get environment specific information: Root directories and name separator character
В· FILE_TYPE: get_parent() method

System Requirements:

No special requirements.
Program Release Status: Minor Update
Program Install Support: Install and Uninstall

Oracle PL/SQL executing OS Commands Tags:

Click on a tag to find related softwares

Is Oracle PL/SQL executing OS Commands your software?

Manage your software

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application