Re: Generate SQL*Loader Control File

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Wed, 14 Jul 1999 17:56:09 +0100
Message-ID: <7mibvp$7m1$1@freeside.cls.net>

Hi Kevin,

Use UTL_FILE - Package
Make sure that database-parameter UTL_FILE_DIR is set to an existing directory or * (dangerous!)

Procedure utl_test is
Textfile UTL_FILE.FILE_TYPE;
BEGIN
Textfile:=UTL_FILE.FOPEN('c:\temp\','PA_SORT.SQL','w'); UTL_FILE.PUT_LINE(Textfile,'I am the walrus!'); UTL_FILE.FCLOSE(Textfile);
END; Bye
Uli

Kevin Cheung <kcheung_at_poboxes.com> schrieb in im Newsbeitrag: 378CADBE.A2C98877_at_poboxes.com...
> I tried to write an anonymouse PL/SQL block to dynamically generate
> control file for loading data. DBMS_OUTPUT.PUT_LINE is used to echo
> output but the buffer is only 1000,000 bytes which is not enough for
> large tables, i.e with 200-300 columns. Pro*C is not considered as this
> product is not installed in our shop. Anyone has any suggestion?
>
> Thanks,
> Kevin
>
Received on Wed Jul 14 1999 - 11:56:09 CDT