Shell Commands From PL/SQLPosted: 20/11/2010
Using a Java stored procedure it is possible to perform shell commands from PL/SQL:
- Create the Java Stored Procedure
- Publish the Java call specification
- Grant Privileges
- Test It.
- Known Issues.
Create the Java Stored Procedure
First we need to create the Java class to perform the shell command.