From oracle-l-bounce@freelists.org Thu Jul 22 09:20:05 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6MEJjX19684 for ; Thu, 22 Jul 2004 09:19:55 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6MEJZ619637 for ; Thu, 22 Jul 2004 09:19:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 305D972D5AE; Thu, 22 Jul 2004 08:58:44 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01850-42; Thu, 22 Jul 2004 08:58:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA7A772D58E; Thu, 22 Jul 2004 08:58:27 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 22 Jul 2004 08:56:45 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8892872CBC0 for ; Thu, 22 Jul 2004 08:56:44 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00630-51 for ; Thu, 22 Jul 2004 08:56:44 -0500 (EST) Received: from exchsen0a1rb.dfa.state.ny.us (exchsen0a1rb.dfa.state.ny.us [198.22.236.247]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D2A9372CEE7 for ; Thu, 22 Jul 2004 08:56:43 -0500 (EST) Received: from snysdolmail1.labor.state.ny.us ([172.16.96.117]) by exchsen0a1rb.dfa.state.ny.us with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id PBFK15QX; Thu, 22 Jul 2004 10:24:29 -0400 Received: by snysdolmail1.labor.state.ny.us with Internet Mail Service (5.5.2650.21) id ; Thu, 22 Jul 2004 10:22:52 -0400 Message-ID: X-Sybari-Trust: 0861892c 60b8330e 85f87662 0000013d From: "Mercadante, Thomas F" To: "'oracle-l@freelists.org'" Cc: "'davewendelken@earthlink.net'" Subject: RE: sql loader problem Date: Thu, 22 Jul 2004 10:22:52 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5759 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org David, Try changing it as follows: (DATACALL terminated by "," , ,QUESTIONID terminated by "," , ,ORGID terminated by "," , ,ANSWER01 terminated by "," , ,ANSWER02 terminated by "," ) SqlLdr gets weirded out when you start using things like INTEGER. If you just tell it how to get the data, it will convert it to the correct data type. Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- From: david wendelken [mailto:davewendelken@earthlink.net] Sent: Thursday, July 22, 2004 10:11 AM To: oracle-l@freelists.org Subject: sql loader problem I don't use sqlldr very often and I'm having a problem I don't understand. I'm getting this error: ORA-01460: unimplemented or unreasonable conversion requested I've slogged thru the online sqlldr manual and the error manual, but I'm not seeing why I'm getting this problem at all. I've stripped out all the fancy stuff I was trying to do, just to get the raw basics to work. But no luck! Oracle9i Enterprise Edition Release 9.2.0.5.0 Here's a sample from the simple comma-delimited file I'm trying to load: 3,1244,14,R4806W,17 3,1244,15,R6606,26 3,1244,16,R2901E,59 3,1244,17,R4501H,112 3,1244,19,R2516,0 3,1244,20,R6312,75 Here's the test table to load into: SQL> descr ltest Name Type --------------------------- --------------- DATACALL NUMBER(2) QUESTIONID NUMBER(10) ORGID NUMBER(10) ANSWER01 VARCHAR2(4000) ANSWER02 VARCHAR2(4000) Control file I'm using: LOAD DATA INFILE '1244.csv' BADFILE '1244.bad' DISCARDFILE '1244.dsc' APPEND INTO TABLE ltest REPLACE FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (DATACALL INTEGER(2) ,QUESTIONID INTEGER(10) ,ORGID INTEGER(10) ,ANSWER01 VARCHAR ,ANSWER02 VARCHAR ) Here's the results I get from the log: Table LTEST, loaded from every logical record. Insert option in effect for this table: REPLACE TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- DATACALL FIRST 2 INTEGER QUESTIONID NEXT 10 INTEGER ORGID NEXT 10 INTEGER ANSWER01 NEXT * VARCHAR ANSWER02 NEXT * VARCHAR Record 1: Rejected - Error on table LTEST. ORA-01460: unimplemented or unreasonable conversion requested Record 2: Rejected - Error on table LTEST. ORA-01460: unimplemented or unreasonable conversion requested Record 3: Rejected - Error on table LTEST. ORA-01460: unimplemented or unreasonable conversion requested Record 4: Rejected - Error on table LTEST. ORA-01460: unimplemented or unreasonable conversion requested Record 5: Rejected - Error on table LTEST. ORA-01460: unimplemented or unreasonable conversion requested Record 6: Rejected - Error on table LTEST. ORA-01460: unimplemented or unreasonable conversion requested ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------