Oracle PL/SQL executing OS Commands v.0.6.2


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

Oracle PL/SQL executing OS Commands project ... PL/SQL executing shell (operating system) commands: OS_COMMAND and FILE_TYPE ...

  • Oracle PL/SQL executing OS Commands
  • 0.6.2
  • Carsten Czarski
  • Linux
  • Freeware
  • 51 Kb
  • 332
  • Free

Review Oracle PL/SQL executing OS Commands

  • captcha
New Database Management software
  • Advanced Data Generator  v. test data generator tool with data library to generate life like data. Ability to generate complex data for volume testing, demo data for presentations or performance testing.
  • Geodata Germany  v.25.00The database contain geodata of the Federal Republic of Germany with geo referenced towns, municipalities, town quarters, administrative units, postal codes, telephone preselections, nature areas, landscapes, climatic zones for proximity searches ec.
  • DataNumen SQL Recovery  v.5.2DataNumen SQL Recovery is a powerful tool to repair and recover corrupt SQL Server MDF database files.
  • Cisdem ContactsMate for Mac  v.5.6.0Cisdem ContactsMate for Mac can manage, edit and fix dozens of problems from mac contacts, also export Mac Address Book to some formats for easy backup or sync.
  • Django-currencies  v.0.2.4django-currencies allows you to define different currencies, and includes template tags/filters to allow easy conversion between them.
  • Ora2pg  v.8.9Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema.