?
Solved

SQL Loder

Posted on 2001-07-24
7
Medium Priority
?
1,025 Views
Last Modified: 2008-03-10
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
0
Comment
Question by:rac13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 2

Expert Comment

by:Kong
ID: 6316275
Instead of varchar2 use char
0
 
LVL 2

Expert Comment

by:ddandekar
ID: 6316278
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
 
LVL 2

Accepted Solution

by:
jbever earned 60 total points
ID: 6316287
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:rac13
ID: 6316381
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
 
LVL 2

Expert Comment

by:jbever
ID: 6316390
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
 

Author Comment

by:rac13
ID: 6316443
Thanks, jbever had given me an answer closer to my problems so I decided to give hom the points. Thanks everyone. :)
0
 

Author Comment

by:rac13
ID: 6412050
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

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question