|
|
| Re: ORA-06532: Subscript outside of limit [message #189867 is a reply to message #189854] |
Mon, 28 August 2006 03:47   |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
