Re: Calling SQL*Loader from and Oracle Form

[Quoted] Frank, thanks for the help. I have not been looking in the ng recently and am [Quoted] not aware of questions on calling external procs on a different platform. If [Quoted] it is NT, I can map the drive, but if the server is UNIX (NT workstation and [Quoted] Sun Sparc server), could you give me a brief idea of how this is accomplished? Thanks!!!

Frank wrote:

> Yep, but I would opt for the server version, unless there are grave
> arguments
> against this approach:
> - you will eliminate network traffic
> - it will be much faster on the server
> - you will not be depending on the clients' configuration.
>
> External procs calling and other commands have been discussed in this ng
> numerous times.
>
> my 2c,
> --
> Frank
> DanHW <danhw_at_aol.com> schreef in berichtnieuws
> 20000905205133.07878.00001299_at_ng-fo1.aol.com...
> > >Is it possible to call SQL*Loader from and Oracle Form running on
> > >Windows NT (wrkst)? If so, what SQL*Loader runs, the one on the client
> > >station or the one on the server? I was under the impression that the
> > >one on the server could only be run from the command line or from a
> > >shell script. Any help appreciated...
> > >
> > >
> > I think the program is SQLDR8.exe now, on NT workstation. You might need
 to get
> > it off a Oracle DB install for NT, not a typical client install...
> >
> > Once you find it, from forms, you can use the HOST command to start a
 program
> > on the client.
> >
> > HTH
> > Dan Hekimian-Williams
> >
> >
Received on Wed Sep 06 2000 - 13:51:06 CEST