Home » RDBMS Server » Server Utilities » ERROR 350
ERROR 350 [message #400380] Mon, 27 April 2009 23:42 Go to next message
ayay
Messages: 5
Registered: April 2009
Location: Indonesia
Junior Member

Dear All,

I try load txt file using sql loader, and find error :
SQL*Loader-350: Syntax error at line 1,
expection keyword load, found " l". what mean this error? please help me.


thank you,


Yayan
Re: ERROR 350 [message #400382 is a reply to message #400380] Mon, 27 April 2009 23:48 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>what mean this error?
Something is wrong.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

Re: ERROR 350 [message #400384 is a reply to message #400380] Tue, 28 April 2009 00:09 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Don't report messages in order to get attention.
Reporting is for messages that are offensive or in other ways need the attention of moderators. NOT to get answers quicker. (In fact, most of the time this works contra-productive)
Re: ERROR 350 [message #400418 is a reply to message #400384] Tue, 28 April 2009 02:13 Go to previous messageGo to next message
ayay
Messages: 5
Registered: April 2009
Location: Indonesia
Junior Member

thank you for your information


Br,


ayay
Re: ERROR 350 [message #400457 is a reply to message #400418] Tue, 28 April 2009 04:57 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
SQL*Loader-350: Syntax error at line 1,
expection keyword load, found " l". what mean this error? please help me.


Post your SQLLDR command we will try to help you.

Babu
Re: ERROR 350 [message #400484 is a reply to message #400457] Tue, 28 April 2009 06:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gentlebabu wrote on Tue, 28 April 2009 11:57
Quote:
SQL*Loader-350: Syntax error at line 1,
expection keyword load, found " l". what mean this error? please help me.


Post your SQLLDR command we will try to help you.

Babu

And control file

Regards
Michel
Re: ERROR 350 [message #400518 is a reply to message #400457] Tue, 28 April 2009 09:47 Go to previous messageGo to next message
ayay
Messages: 5
Registered: April 2009
Location: Indonesia
Junior Member

this sqlldr command and control file

sqlldr userid=report/report control=D:\yayan\colector.ctl

LOAD DATA
INFILE 'D:\yayan\data.txt'
INTO TABLE colector
FIELDS TERMINATED BY ";" OPTIONALLY TRAILING NULLCOLS
(name_file,coll_start,coll_end,file_size,source_id,file_record)


Regard,


Yayan
Re: ERROR 350 [message #400527 is a reply to message #400518] Tue, 28 April 2009 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT what you did when you got the error.
Post what you REALLY did.

Regards
Michel
Re: ERROR 350 [message #400678 is a reply to message #400527] Wed, 29 April 2009 04:38 Go to previous messageGo to next message
ayay
Messages: 5
Registered: April 2009
Location: Indonesia
Junior Member

I got the error, when I ran command
sqlldr userid=report/report control=D:\yayan\colector.ctl
Re: ERROR 350 [message #400687 is a reply to message #400380] Wed, 29 April 2009 04:59 Go to previous messageGo to next message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
Oracle is complaining about a | being in the wrong place.
The code you've posted doesn't contain a |
Oracle is not known to make these things up.

Therefore we can only assume the code for the control file you have posted is not the code that is being run.
Re: ERROR 350 [message #400710 is a reply to message #400687] Wed, 29 April 2009 05:59 Go to previous messageGo to next message
ayay
Messages: 5
Registered: April 2009
Location: Indonesia
Junior Member

but why when I tried on unix successfull didn't get error
Re: ERROR 350 [message #400721 is a reply to message #400710] Wed, 29 April 2009 06:34 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because what you posted is not EXACTLY what you did.

Regards
Michel
Previous Topic: Are there any defragment tools?
Next Topic: SQL Loader to load single row into multiple rows
Goto Forum:
  


Current Time: Thu Dec 08 00:06:48 CST 2016

Total time taken to generate the page: 0.11803 seconds