Re: call sql loader from and procedure???
From: HansF <News.Hans_at_telus.net>
Date: Sat, 04 Jun 2005 02:03:08 GMT
Message-Id: <pan.2005.06.04.02.06.01.682803_at_telus.net>
Date: Sat, 04 Jun 2005 02:03:08 GMT
Message-Id: <pan.2005.06.04.02.06.01.682803_at_telus.net>
On Fri, 03 Jun 2005 13:39:11 -0700, jeffchirco interested us by writing:
> Is it possible to call and run sql loader from an Oracle procedure?
Sure. Just remember that SQL Loader is an Operating System executable. Then realize that one way of executing operating system stuff from PL/SQL is called 'external procedures'.
Or learn to use Oracle's Enteprrise manager - in 10g you have a real handy scheduler.
-- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries ***Received on Sat Jun 04 2005 - 04:03:08 CEST