PL/SQL (MOSC)

MOSC Banner

Load rows from CSV to table

edited Jun 16, 2011 3:59AM in PL/SQL (MOSC) 14 commentsAnswered
Hi,

I have a customised table into which rows from a CSV file have to be loaded.

When I run the sqlload command from UNIx , it creating a log file with the following message. Can anyone suggest how to resolve the error :

CTL file :

OPTIONS(ERRORS=1000000)
LOAD DATA APPEND INTO TABLE hris_temp
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(  hris_personid                       "UPPER(TRIM(:personid))", 
last_name                              "UPPER(TRIM(:lastname))", 
first_name                           "UPPER(TRIM(:firstname))",  company_email_address       "UPPER( TRIM(:CompanyEmailAddress))"
 ) 

Log file :


SQL*Loader: Release 8.0.6.3.0 - Production on Mon Jun 13 10:01:33 2011

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center