Sql * Loader -350 [message #70649] |
Wed, 10 July 2002 19:53 |
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 #70658 is a reply to message #70654] |
Wed, 10 July 2002 23:42 |
|
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 |
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".
|
|
|