Re: How to execute system command on DBMS server machine?

From: RHC <rclarence_at_juno.com>
Date: Wed, 28 Feb 2001 20:30:06 -0000
Message-ID: <t9qnueo4ee26f5@corp.supernews.com>

Yes, you can create an external procedure call. You create the code in C and compile it into a shared library. You then create a PL/SQL wrapper for the external C program. You can do the same thing with a java stored procedure. For an example in C, check out Oracle8 PL/SQL programming, chapter 20. If you know Java you can forgo the whole compiling to a shared library thing since there is a JVM in the 8i.

HTH
RHC PJ wrote:
>
>
> Is there any way to execute system commands (for example 'copy file')
> from PL/SQL stored procedures on server machine that hosts Oracle
> RDMBS 8i ?
>
> Thanks in advance
> PJ

--
Posted via CNET Help.com
http://www.help.com/

Received on Wed Feb 28 2001 - 14:30:06 CST