Re: Calling SQL*Loader from and Oracle Form
From: Frank <frankbo_at_interaccess.nl>
Date: Wed, 6 Sep 2000 14:03:06 +0200
Message-ID: <8p5bqg$9cj$1_at_porthos.nl.uu.net>
Date: Wed, 6 Sep 2000 14:03:06 +0200
Message-ID: <8p5bqg$9cj$1_at_porthos.nl.uu.net>
Denny,
I'm not into calling external procs, so can"t really help you here,
but it is on the *same* platform - you will end up with a procedure in the
database
(that is getting called from the client, yes) that opens an external call to
the sqlload
utility on the very same machine.
You probably could also use the utlfile option, but sqlloader will be more
efficient.
Besides, you did state sql*loader, so this is slightly off-topic.
If you insist on the client, the procedure would be on the client side, but (os differences apart) all else would be the same.
-- Frank Denny Dutcavich <dut_at_mindspring.com> schreef in berichtnieuws 39B62FAA.70993C22_at_mindspring.com...Received on Wed Sep 06 2000 - 14:03:06 CEST
> Frank, thanks for the help. I have not been looking in the ng recently and
am
> not aware of questions on calling external procs on a different platform.
If
> it is NT, I can map the drive, but if the server is UNIX (NT workstation
and
> 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
> > >
> > >
>