Home » RDBMS Server » Server Utilities » Sql * Loader -350
Sql * Loader -350 [message #70649] Wed, 10 July 2002 19:53 Go to next message
sharu
Messages: 5
Registered: June 2002
Junior Member
Hi,
I am trying to load data using sql* loader and it is giving an error like

SQL* Loader -350 : syntax error at line 1.
expecting keyword Load, Found "attribute".
attribute VB_Name = "Module1"

i saved my control file as .ctl and when i try to open that it is opening with MICROSOFT VISUAL BASIC WINDOW.
why is this so? how do i get rid of this problem

Thanks in advance
Re: Sql * Loader -350 [message #70650 is a reply to message #70649] Wed, 10 July 2002 19:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
can you post the .ctl file

[Updated on: Thu, 09 August 2012 04:24]

Report message to a moderator

Re: Sql * Loader -350 [message #70652 is a reply to message #70649] Wed, 10 July 2002 20:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
or change like
Load Data
infile 'c:resmydata.csv'
fields terminated by "," optionally enclosed by '"'
into table t1 ( N,C,I)
Re: Sql * Loader -350 [message #70654 is a reply to message #70649] Wed, 10 July 2002 21:10 Go to previous messageGo to next message
sharu
Messages: 5
Registered: June 2002
Junior Member
now it is giving sql*loader-524 partial record exists at the end of the data file..
Re: Sql * Loader -350 [message #70658 is a reply to message #70654] Wed, 10 July 2002 23:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Ensure that a linefeed exists after the end of the last line in the
SQL*Loader control file, datafile and parfile.  Follow these steps 
to correct the problem: 
1. Using a text editor, binary file editor, or a hex editor, you append
   a linefeed character to the end of the last line in the SQL*Loader 
   control   file,  datafile and parfile..    
   i.   text editor (eg. vi, ed, edit, etc) - hit the return / enter key while 
                                              at the end of the last line in the
					      file  
   ii.  binary / hex editor (eg. tr, hexedit, etc)- append hex value 0A 
					     ( decimal value 10 ) to the end of the file   
NOTE:  Using NOTEPAD will not work. 
2. Save the file. 3. Re-run SQL*Loader using the edited files.
Re: Sql * Loader -350 [message #70669 is a reply to message #70649] Thu, 11 July 2002 07:12 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
When you installed VB the application associated the file type".ctl" with VB. If you want to change it (i wouldn't) then use help and do a lookup on "associate a file extension with a file type".
Previous Topic: Re: general information on importing
Next Topic: SQL Loader combining fields
Goto Forum:
  


Current Time: Mon Dec 23 06:37:29 CST 2024