Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how can I invoke SQLLoader with PL/SQL
in the sense of portability using utl_file within PL/SQL would be the most
elegant way
to solve my problem, no doubt. for that reason it was indeed the first
strategy to solve
my problem. the reasons why I want to use SQLloader now are
1) SQLloader kind of 'knows' a lot about input data files. think of the
treatment
of logical/physical records for instance, and as you mentioned, utl_file is a kind of ... hmmm... C code level ;-)) 2) I have to do massive loads and I feer a performance lack using utl_file in
interpreted PL/SQL. Though I must admit this is only a suggestion, I never
really tried to load data with utl_file. has anyone? thanks for thinking about my problem,
--marcus
bonanos_at_yahoo.com schrieb in Nachricht <6untdq$1ue$1_at_nnrp1.dejanews.com>...
>
>
>
>> I am looking for a somewhat smart approach to call foreign applications
>> like z.b SQLLoader from the database, similar to the host command
>> in forms. the purpose would be having running PL/SQL code in the database
>> in batch( using DBMS_job) maintaining a periodical data transfer into the
>> database.
>> i am using oracle 7.3.4 on windows NT, but I am looking for a general
>> approach that should also work on for instance any unix platform.
>> any idea?
>
>The way you would do the code is different on NT and UNIX as far as i know,
>one way to do data loads is to use the UTL_FILE package this allows you to
>read files, the only problem is that it is lightly low level, so you would
>have to do a bit of coding.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 29 1998 - 04:56:01 CDT