Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calling OS commands form PL/SQL

Re: Calling OS commands form PL/SQL

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Sat, 7 Oct 2000 22:25:22 -0700
Message-ID: <wxTD5.23329$XV.1376112@nntp3.onemain.com>

The Java one works and the example is UNIX based but it also works in DOS. The catch is that you have to pass the complete path to the executable you want to run. in UNIX this might be /usr/bin/ls -l in DOS this might be c:\winnt\system32\del ....
Jim
"Jeremy Smith" <jeremy.d.smith_at_bigfoot.com> wrote in message news:P3OD5.19866$uq5.403099_at_news6-win.server.ntlworld.com...
> Does anyone know how I can call DOS commands from PL/SQL to copy and
 delete
> files.
> I am running v8.1.6 on Windows NT.
> Or acle support have told me I can use extproc to call a C routine, which
> isn't much help as I don't have a C compiler.
> They have also suggested using Java, but the script they suggested like
 all
> the other ones in their knowledge base seems to only be good for Unix.
>
> help me!
> thanks
> Jez
>
>
Received on Sun Oct 08 2000 - 00:25:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US