Hi:
How Could I execute an HpUX command from an Oracle pl/sql
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
when you are in SQL you can use "!" sign before the command to execute. I am not sure how you can use this in PS/SQL.
Example:
SQL> !ls -ltr
total 64
drwx------ 2 psft dba 96 Jul 31 16:23 Mail
-rw-r--r-- 1 psft dba 186 Aug 19 21:07 recere.sql
-rw-r--r-- 1 psft dba 8301 Aug 19 21:16 A.sql
drwxr-xr-x 3 psft dba 8192 Sep 6 14:42 Scri
SQL>
All the best.
Raj
Hi,
May be if you give us details of what it is you are trying to do we can suggest something. For example, it's possible to create an OS file using UTL_FILE package and then execute it (you can execute it from crontab or manually). Other than that I am not aware of a direct execution of Unix commands from PL/SQL.
Also you can write a SQL (not PL/SQL) script that uses the spool command. spool will create an OS file that you can then execute. It's easy to create a Unix shell script that will connect to Oracle so some stuff, spool it and then execute it.
For example, the script below can be saved to a file and executed from Unix shell.
This script checks for invalid objects and generates a script to execute the alter statements.
#!/bin/ksh
. ~/.profile
export COM1="/ as sysdba"
export COM2="sqlplus -s /nolog"
$COM2 <<ESQL
connect $COM1
set pagesize 0
set heading off
set feedback off
select 'alter '||decode(object_type, 'PACKAGE BODY', 'PACKAGE', object_type)||' '||owner||'.'||'"'||object
pe, 'PACKAGE', ' package;', 'PACKAGE BODY', ' body;', 'VIEW', ';', ';') from dba_objects where object_type in ('FUNCTION', 'PROCEDURE', 'PACKA
GE', 'PACKAGE BODY', 'VIEW', 'TRIGGER') and status = 'INVALID' order by object_type;
spool recomplist.sql
/
spool off
set feedback on
@recomplist
set pagesize 20000
set heading on
exit
ESQL
OR
you can actually connect to Oracle yourself and then run just the middle part:
set pagesize 0
set heading off
set feedback off
select 'alter '||decode(object_type, 'PACKAGE BODY', 'PACKAGE', object_type)||' '||owner||'.'||'"'||object
pe, 'PACKAGE', ' package;', 'PACKAGE BODY', ' body;', 'VIEW', ';', ';') from dba_objects where object_type in ('FUNCTION', 'PROCEDURE', 'PACKA
GE', 'PACKAGE BODY', 'VIEW', 'TRIGGER') and status = 'INVALID' order by object_type;
spool recomplist.sql
/
spool off
set feedback on
@recomplist
set pagesize 20000
set heading on
Hopes it answers some of your questions,
sdrozd
you can issue unix commands from within a pl/sql procedure if you have oracle 8i or up. do the following:
insert this java procedure into the database:
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "HOST" AS
import java.lang.*;
import java.io.*;
public class Host
{
public static void executeCommand (String command, String etype) throws IOException
{
String[] wFullCommand = {"C:\\winnt\\system32\\cmd
String[] uFullCommand = {"/bin/sh", "-c", command};
if (etype.toUpperCase().equal
Runtime.getRuntime().exec(
else if(etype.toUpperCase().equ
Runtime.getRuntime().exec(
else if(etype.toUpperCase().equ
Runtime.getRuntime().exec(
}
};
/
now compile this pl/sql wrapper procedure in the database:
CREATE OR REPLACE PROCEDURE Host_Command_Proc (p_command IN VARCHAR2, p_etype IN VARCHAR2)
AS LANGUAGE JAVA
NAME 'Host.executeCommand (java.lang.String, java.lang.String)';
/
to issue a unix command to remove all files from a directory for example, you would put this line in your pl/sql procedure:
host_command_proc ('cd home/yourdir/another_dir',
host_command_proc ('rm -f *', 'U+');
**note: for this to work you must have the correct java classes loaded in the database.
if you have any more questions on how this works post back.
Business Accounts
Answer for Membership
by: seazodiacPosted on 2003-10-08 at 08:38:15ID: 9514034
if you can, it will a very daunting challenge...
the easy workaround is that you create a java stored procedure in which java PROCESS can execute some operating system commands, and grant the proper privilege at the OS level, and in your plsql program , you call that java stored procedure.
there is a detailed example here:
see http://asktom.oracle.com/p