OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » ERROR 350

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ERROR 350 [message #400380]

Mon, 27 April 2009 23:42

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

Report message to a moderator

Re: ERROR 350 [message #400382 is a reply to message #400380]

Mon, 27 April 2009 23:48

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: ERROR 350 [message #400384 is a reply to message #400380]

Tue, 28 April 2009 00:09

Frank
Messages: 7901
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)

Report message to a moderator

Re: ERROR 350 [message #400418 is a reply to message #400384]

Tue, 28 April 2009 02:13

ayay
Messages: 5
Registered: April 2009
Location: Indonesia

Junior Member

thank you for your information

Br,

ayay

Report message to a moderator

Re: ERROR 350 [message #400457 is a reply to message #400418]

Tue, 28 April 2009 04:57

babuknb
Messages: 1736
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

Report message to a moderator

Re: ERROR 350 [message #400484 is a reply to message #400457]

Tue, 28 April 2009 06:37

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: ERROR 350 [message #400518 is a reply to message #400457]

Tue, 28 April 2009 09:47

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

Report message to a moderator

Re: ERROR 350 [message #400527 is a reply to message #400518]

Tue, 28 April 2009 10:22

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: ERROR 350 [message #400678 is a reply to message #400527]

Wed, 29 April 2009 04:38

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

Report message to a moderator

Re: ERROR 350 [message #400687 is a reply to message #400380]

Wed, 29 April 2009 04:59

cookiemonster
Messages: 13920
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.

Report message to a moderator