OraFAQ Forum: Server Administration » How to execute a unix command from Oracle ?

Home » RDBMS Server » Server Administration » How to execute a unix command from Oracle ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to execute a unix command from Oracle ? [message #118704]

Sat, 07 May 2005 02:33

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

Is there a way to execute a unix command or even a .sh script from a PL/SQL block ? Should I use Java ? Any example ?

Thanks

Report message to a moderator

Re: How to execute a unix command from Oracle ? [message #118711 is a reply to message #118704]

Sat, 07 May 2005 03:53

tycoonajayverma
Messages: 17
Registered: May 2005
Location: b'lore

Junior Member

hi

the java part i don't know that
.sh is use to run from shell and sqlplus is not the shell or i dont know but u can run commands from sqlplus
expample is below.
!top
!ls -ls
!df -km

but the alias is not work like this

Thanks

Report message to a moderator

Re: How to execute a unix command from Oracle ? [message #118737 is a reply to message #118711]

Sat, 07 May 2005 10:57

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://asktom.oracle.com/pls/ask/f?p=4950:8:5464026578908842260::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:952229840241

Report message to a moderator

Previous Topic:	need oracle 8.1.7.4 on solaris
Next Topic:	ideal sessions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 20 23:11:09 CDT 2026