Re: SQL*Loader - run stored procedure

From: Volker Pohlers <vpohlers_at_arcor.de>
Date: Wed, 07 Sep 2005 16:30:38 +0200
Message-ID: <431ef98f$0$2113$9b4e6d93_at_newsread2.arcor-online.net>


HansF schrieb:
> 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.
>
tip: google for pl loader.
Release 1.4 was free on sourceforge

PLLoader is a fast data processing engine for populating and manipulating data within Oracle databases. PLLoader provides a simple and intuitive interface for many data loading applications by allowing any SQL or PL/SQL to be executed for each line in the input file. PLLoader provides this flexibility while processing at speeds far faster than conventional SQL*Load processing.

Actions are defined in PLLoader using standard SQL and PL/SQL, consequently the interface is immediately familiar to those who have previously used the Oracle SQL and PL/SQL interfaces.

Volker Received on Wed Sep 07 2005 - 16:30:38 CEST

Original text of this message