Re: Executing UNIX commands from Oracle

In <daveguyD3t5sA.CFw_at_netcom.com> daveguy_at_netcom.com (David Dietrich) writes:

>This has to be a no brainer for some of you folks.

No, its a good question... I'll give my $0.02 worth :->
>[...] can i [...] have a stored procedure actually execute
>operating system commands? I want to: present a form to the Access user,
>update the backend, and kick-off a UNIX script. We're using SQL/net and
>ODBC to connect. What is the SQL statement in Oracle to execute an
>operating system command? I hope this post isn't too light weight! I'm
>doing the UNIX scripts, and the project DBA isn't certain. Any help would
>be appreciated.

You could not do this directly, as far as I know. The only thing I can think of is to use the ORACLE database pipe packaged procedures to set up a client-server type arrangement. I haven't got the manuals to hand but the concept is that :-

1. A server process (implemented in Pro*C for example) listens on a pipe
2. your stored procedure passes the script details down the pipe
3. the server uses the system() call to execute the script

>David Dietrich - daveguy_at_netcom.com

I hope this helps,

--
Mark Bluemel	Unix/Oracle Trainer and Consultant
		My opinions are my own, but I'll share them
		All solutions to problems are offered "as is"
		and without warranty - you have been warned :-)