Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Loader-704

vpolasaSep 10 2009 — edited Sep 10 2009
I'm trying to execute a control file.

Below is the error message
SQL*Loader: Release 10.2.0.1.0 - Production on Thu Sep 10 10:54:10 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error
ulcase4.dat
*7782 CLARK  MANAGER   7839 2572.50 -10     10 12-NOV-85
*7839 KING   PRESIDENT      5500.00         20 05-APR-83
*7934 MILLER CLERK     7782 920.00          10 08-MAY-80
*7566 JONES  MANAGER   7839 3123.75         30 17-JUL-85
*7499 ALLEN  SALESMAN  7698 1600.00 300.00  10 03-JUN-84
*7654 MARTIN SALESMAN  7698 1312.50 1400.00 30 21-DEC-85
*7658 CHAN   ANALYST   7566 3450.00         20 16-FEB-84
ulcase4.ctl
LOAD DATA
   INFILE 'c:\data\ulcase4.dat'
   DISCARDFILE 'ulcase4.dsc'
   DISCARDMAX 999
   REPLACE
   CONTINUEIF THIS (1) = "*"   
   INTO TABLE emp
  (empno         POSITION(1:4)         INTEGER EXTERNAL,
   ename         POSITION(6:11)        CHAR,
   job           POSITION(13:21)       CHAR,
   mgr           POSITION(23:26)       INTEGER EXTERNAL,
   sal           POSITION(28:34)       DECIMAL EXTERNAL,
   comm          POSITION(36:42)       DECIMAL EXTERNAL,
   deptno        POSITION(44:45)       INTEGER EXTERNAL,
   hiredate      POSITION(47:55)       DATE)
What could be the reason? Thanks.
This post has been answered by Solomon Yakobson on Sep 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2009
Added on Sep 10 2009
10 comments
32,043 views