Re: SQL*Loader - run stored procedure

From: HansF <News.Hans_at_telus.net>
Date: Mon, 05 Sep 2005 14:46:00 GMT
Message-Id: <pan.2005.09.05.14.50.21.549932_at_telus.net>


[Quoted] Turn this around a bit. Assuming you are using a reasonable version of Oracle (which you don't mention, so all of this is speculation)

If you use external tables (CREATE TABLE ... ORGANIZATION EXTERNAL), you can access the CSV files directly as a [read only] table instead of a simple load file. That means you can use the data file as a table source in the read portion of any INSERT, UPDATE, DELETE or SELECT. And that in turn means you can use it from a stored procedure.

-- 
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 Mon Sep 05 2005 - 16:46:00 CEST

Original text of this message