Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06532: Subscript outside of limit
ORA-06532: Subscript outside of limit [message #189854] Mon, 28 August 2006 02:13 Go to next message
tom01
Messages: 29
Registered: July 2006
Junior Member
Hello!

Can anybody help me with the following error:

ORA-06532: Subscript outside of limit

I try to upload a csv file with 20 columns.

Tom
Re: ORA-06532: Subscript outside of limit [message #189867 is a reply to message #189854] Mon, 28 August 2006 03:47 Go to previous messageGo to next message
gbarbisan
Messages: 67
Registered: August 2006
Location: Treviso - Italy
Member
ORA-06532 Subscript outside of limit
Cause: A subscript was greater than the limit of a VARRAY or non-positive for
a VARRAY or nested table.
Action: Check the program logic and increase the VARRAY limit if necessary.
Re: ORA-06532: Subscript outside of limit [message #189960 is a reply to message #189854] Mon, 28 August 2006 13:57 Go to previous message
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member

Hi,


here i have taken all data and columns from employees table

Consider my ctl file is appended below
save this code as d:\employee.ctl



options(direct=true)
load data
infile 'd:\utl_dir\emp2.txt'
BADFILE 'd:\dummy\employees.bad'
DISCARDFILE 'd:\dummy\employees.dsc'
into table employees1
fields terminated by '|'
TRAILING NULLCOLS
(employee_id, first_name, last_name, email,phone_number, hire_date, job_id,
salary, commission_pct, manager_id, department_id)



your text file ( data) seperated by '|' shoud be in d:\utl_dir\emp2.txt
if data is in other place please make chages in ctl file also


make sure employees1 table is in scott schema also with no data

run in cmd prompt as

c:\ sqlldr scott/tiger@orcl contrl = d:\employees.ctl
Previous Topic: SQL Query Performance Problem
Next Topic: Pre Compiler
Goto Forum:
  


Current Time: Thu Dec 08 10:04:01 CST 2016

Total time taken to generate the page: 0.10054 seconds