Solved

SQL Loder

Posted on 2001-07-24
7
993 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 15 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

695 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