Re: how can I invoke SQLLoader with PL/SQL

From: <bonanos_at_yahoo.com>
Date: Mon, 28 Sep 1998 11:54:34 GMT
Message-ID: <6untdq$1ue$1@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 Mon Sep 28 1998 - 06:54:34 CDT