SQL Loder

I try to load a file in SQLLoader, but it gives me an error. Then when I try to change the file, I cannot have access to the file. Why is it so? Below is the things that I did. Thanks

$ loadInventory.sh

SQL*Loader: Release 7.3.2.2.0 - Production on Wed Jul 25 12:49:37 2001

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

SQL*Loader-350: Syntax error at line 5.
Expecting valid column specification, "," or ")", found "varchar2".
(CODE   position(01:08) varchar2,
                      ^
$ vi loadInventory.sh
"/ext1/app/oracle/product/7.3.2.2/tmp/Ex25775" Permission denied
rac13Asked:
Who is Participating?
 
jbeverConnect With a Mentor Commented:
Hi Rac13

SQLloader only knows CHAR, Integer external, Decimal external and DATA data types.

So you need to user CHAR instead of varchar2.

J.
0
 
KongCommented:
Instead of varchar2 use char
0
 
ddandekarCommented:
For position based parameters for SQL Loader the column specification would be char and not varchar2.

Perhaps you can copy the .sh file in your directory and edit it before using.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
rac13Author Commented:
Now I had this error:

SQL*Loader: Release 7.3.2.2.0 - Production on Wed Jul 25 15:09:45 2001

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

SQL*Loader-350: Syntax error at line 5.
Expecting valid column specification, "," or ")", found "number".
QTY     position(15:19) number)
0
 
jbeverCommented:
as i mentioned before:

SQLloader only knows CHAR, Integer external, Decimal external and DATA data types.

so now go for the integer external.

jan.
0
 
rac13Author Commented:
Thanks, jbever had given me an answer closer to my problems so I decided to give hom the points. Thanks everyone. :)
0
 
rac13Author Commented:
Hi jbever,
 
  can we insert word directly using SQLLoader?
Example:
load Data
infile 'tepl_stock.txt'
APPEND into table EXCEPTION
(SKU   position(01:10) char,
QTY     position(18:24) integer external,
REASON char REASON = "Cannot find the cross-reference STMS stock-code")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.