Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.544.820 Times

Oracle PL/SQL executing OS Commands 0.6.2

Company: Carsten Czarski
Date Added: October 09, 2013  |  Visits: 317

Oracle PL/SQL executing OS Commands

Report Broken Link
Printer Friendly Version


Product Homepage
Download (17 downloads)



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.<br /><br />In general there are at least three ways to execute shell commands by the Oracle engine.<br /><br /> 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.<br /> 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.<br /> 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.<br /><br />The package runs in Oracle 10.1 or higher

Requirements: No special requirements
Platforms: *nix, Linux
Keyword: Commands Compiler Database Dbms Scheduler Engine Execute Functionality Operating Oracle Package Plsql Project Required Shell Stdin Stdout System
Users rating: 0/10

License: Freeware Size: 51.2 KB
USER REVIEWS
More Reviews or Write Review


ORACLE PL/SQL EXECUTING OS COMMANDS RELATED
Database Tools  -  Database utility class 1.0
Database utility class can execute SELECT, INSERT, UPDATE and DELETE queries from parameters that define tables, fields, values and conditions.Results from SELECT queries are returned in arrays.
10 KB  
Database Tools  -  MySQL Database abstraction class 1.0
MySQL Database abstraction class emulates the functionality of the PEAR::DB API package, without requiring it. The ADODB package is also partially emulated.
10 KB  
Text Chat Clients  -  ICEL 2
ICEL project provides database-based learning engine for eggdrop bots. ICEL stands for Interactive Commands for E-Learning and consists on a set of .tcl scripts that gives learning capabilities to an eggdrop bot. It has been coded to be used...
21.5 KB  
Database Tools  -  MySQL Abstraction Pro 1.0
MySQL Abstraction Pro can establish connections to a given MySQL database server host and execute SQL queries and return the results in arrays in a single call.Separate classes can be used to process query results for instance to output the...
153.6 KB  
Database Tools  -  MySQL List Data 1.0
MySQL List Data can be used to view, edit and delete records of a MySQL database table. It can execute a MySQL database SELECT query and list the results in an HTML table.The table fields, the respective header names and the table presentation...
40.96 KB  
Web Browser Tools  -  HyperNet Browser 1.0
HyperNet Browser is an innovative combination of four systems: Browser, Spider, Database and Search Engine. With HyperNet you can safely surf the web and automatically scan and store websites locally on your hard drive for private offline...
2.05 MB  
Utilities  -  PHPQstat 1.0
PHPQstat is a web interface that allows to connect to the useful commands of the Sun Grid Engine (SGE) batch queue system. With this interface, you can monitor your job status and your queues health at real time.
19.58 KB  
Automotive Information Databases  -  EMS SQL Manager for Oracle Freeware 2.4
EMS SQL Manager for Oracle Freeware is a high performance database tool for Oracle database development and administration. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to the newest one and supports the latest Oracle Database...
40.47 MB  
Development Editors  -  Neurotranslator 2011-11-12 Alpha
Neurotranslator was specially designed as a compiler using for a new XBNF syntax. Severals inputs and outputs flux (files or stdin/stdout) are usable through XBNF channels. Now you can make use of this utility to improve your development process.
 
Programming  -  APEX Database Control 1.1
Database Control helps developers effectively maintain their Oracle database.
128.67 KB  
NEW DOWNLOADS IN LINUX SOFTWARE, BUSINESS
Linux Software  -  Polling Autodialer Software 3.4
ICTBroadcast Auto Dialer software has a survey campaign for telephone surveys and polls. This auto dialer software automatically dials a list of numbers and asks them a set of questions that they can respond to, by using their telephone keypad....
488 B  
Linux Software  -  Total Video Converter Mac Free 3.5.5
Total Video Converter Mac Free developed by EffectMatrix Ltd is the official legal version of Total Video Converter which was a globally recognized brand since 2006. Total Video Converter Mac Free is a free but powerful all-in-one video...
17.7 MB  
Linux Software  -  Skeith mod_log_sql Analyzer 2.10beta2
Skeith is a php based front end for analyzing logs for Apache using mod_log_sql.
47.5 KB  
Linux Software  -  SLAX 6.0+
Slax is a modern, portable, small and fast Linux operating system with a modular approach and outstanding design. Despite its small size, Slax provides a wide collection of pre-installed software for daily use, including a well organized graphical...
190 KB  
Linux Software  -  GTK+ 2.5
GTK+, which stands for the GIMP Toolkit, is a library for creating graphical user interfaces for the X Window System. It is designed to be small, efficient, and flexible. GTK+ is written in C with a very object-oriented approach. Language bindings...
60 MB  
Business  -  Java SQL Admin Tool for Linux 2.4.3
This is a Java-based Admin-Tool for SQL-Databases via JDBC. It needs to have JDK 1.6 underneath In the beginnings of Java I had my first look at this exciting product. So I decided to learn more about Java. As beeing a developer for...
686.08 KB  
Business  -  DBBalancer 0.4.4
DBBalancer is some sort of middleware that would sit in between of database clients, like C, C++, TCL, Java JDBC, Perl DBI, and a database server. Currently the only server supported is Postgres, but the architecture is open to embrace more...
174.08 KB  
Business  -  Postgres Plus 9.0.4
Postgres Plus is a distribution of PostgreSQL that contains the following additional features integrated in a convenient installation package: Postgres Studio for administration, Procedural Language Debugger, GridSQL Parallel Query, MySQL...
43.06 MB  
Business  -  Insulin Buddy 1.0b
Insulin Buddy is diabetes management software. It allows for quick and painless entry of all diabetes-related data (blood blucose, carbohydrate consumption, insulin doses, etc) and provides a number of reports, charts and data exports to easily...
2.52 MB  
Business  -  Apatar Data Integration 1.12.23
Apatar is an open source Extract, Transform, and Load (ETL) project. Modular architecture delivers: 1. Visual job designer/mapping 2. Connectivity to all major data sources 3. Flexible Deployment Options (GUI, or server engine with JVM, or...
25.94 MB