Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling OS commands form PL/SQL
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