OraFAQ Forum: Server Administration » Execute a file in server with ORACLE

Home » RDBMS Server » Server Administration » Execute a file in server with ORACLE

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

Execute a file in server with ORACLE [message #374469]

Wed, 13 June 2001 17:29

Jesus Limon
Messages: 1
Registered: June 2001

Junior Member

hi

I have oracle(8i) in aix(4.3), and i need execute a shell(prueba.sh), from pl/sql (some procedure),
and i don't know how can i do this.

what is tha command in pl/sql or what i need to do???

thanks in advanced

Chuy

Report message to a moderator

Re: Execute a file in server with ORACLE [message #374484 is a reply to message #374469]

Thu, 14 June 2001 08:11

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

You can not directly execute any shell commands or shell scripts directly from plsql....

You can use either external c proc or
external/internal Java proc to execute the shell script. And call the c or java proc from plsql.

Bala.

Report message to a moderator

Previous Topic:	String concat in CopyCommit statement ( in Oracle 8i)
Next Topic:	SQL statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:52:38 CST 2024