Re: using sql*loader from pl/sql

Kaly wrote:

> is there any method to use sql*loader from pl/sql code?
> i heard about doing it with java classes but i can't use it in my application
>
> thanx
> kaly

And your Oracle has a version?

If 10g look at DBMS_SCHEDULER.

Otherwise go to http://asktom.oracle.com for some solutions.

If 9i or above I wouldn't waste my time with SQL*Loader and look at using external tables.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)