Executing UNIX commands from Oracle

From: David Dietrich <daveguy_at_netcom.com>
Date: Fri, 10 Feb 1995 23:40:58 GMT
Message-ID: <daveguyD3t5sA.CFw_at_netcom.com>


This has to be a no brainer for some of you folks. I'm no DBA, but I play one on TV. Seriously, I have a conceptual thing to ask. If I have a client/server app with a MS Access front end, can I do SQL pass throughs to the Oracle database and 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.

David Dietrich - daveguy_at_netcom.com Received on Sat Feb 11 1995 - 00:40:58 CET

Original text of this message