Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Generate SQL*Loader Control File

Generate SQL*Loader Control File

From: Kevin Cheung <kcheung_at_poboxes.com>
Date: Wed, 14 Jul 1999 23:33:19 +0800
Message-ID: <378CADBE.A2C98877@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 - 10:33:19 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US