List index out of bounds (17)

Getting this error when I try to run this SQL-

select * from mgmt$jobs;

List index out of bounds (17)

I get the results from SQL*Plus but not from TOAD. Please advise

I use TOAD for Oracle 12.10.0.30 version

Can you post the DDL for that table?

ColumnName
ColID
DataType
Null
JOB_NAME
1
VARCHAR2 (64 Byte)
N
JOB_ID
2
RAW (16)
N
JOB_OWNER
3
VARCHAR2 (256 Byte)
N
JOB_DESCRIPTION
4
VARCHAR2 (4000 Byte)
Y
JOB_TYPE
5
VARCHAR2 (64 Byte)
N
TARGET_TYPE
6
VARCHAR2 (64 Byte)
Y
IS_LIBRARY
7
NUMBER (1)
Y
IS_RESTARTABLE
8
NUMBER (1)
Y
START_TIME
9
DATE
Y
END_TIME
10
DATE
Y
TIMEZONE_TYPE
11
VARCHAR2 (40 Byte)
Y
TIMEZONE_REGION
12
VARCHAR2 (64 Byte)
Y
SCHEDULE_TYPE
13
VARCHAR2 (8 Byte)
Y
INTERVAL
14
NUMBER
Y
EXECUTION_HOURS
15
NUMBER (3)
Y
EXECUTION_MINUTES
16
NUMBER (3)
Y
MONTHS
17
MGMT_JOB_INT_ARRAY
Y
DAYS
18
MGMT_JOB_INT_ARRAY
Y

The problem is likely due to something not supported in your MGMT_JOB_INT_ARRAY type. If you give me some SQL to create that type, and to create the table, and insert a few rows, I’ll try to reproduce the problem.

Here is the script for creating the type

CREATE OR REPLACE TYPE SYSMAN.“MGMT_JOB_INT_ARRAY” AS VARRAY(1000000)
OF INTEGER;

scrip for creating the table

CREATE TABLE SYSMAN.MGMT_JOB_SCHEDULE
(
MONTHS SYSMAN.MGMT_JOB_INT_ARRAY,
DAYS SYSMAN.MGMT_JOB_INT_ARRAY,
)
VARRAY MONTHS STORE AS LOB (
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
CACHE
LOGGING
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
))
VARRAY DAYS STORE AS LOB (
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
CACHE
LOGGING
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
))
TABLESPACE MGMT_TABLESPACE

both the columns are null. No data in it

I created that table on my database and inserted a few rows. I can select from it without any problem. When you get the error, do you have an error dialog that says “to see what this error report contains, click here”? If so, click where it says “click here”, then check the “Copy to clipboard” box in the next dialog, and click OK. THen post the contents of your clipboard here. Thanks.

I tried nulls also - no problems here.

I get this error when I run the query

select months,days from SYSMAN.MGMT_JOB_SCHEDULE;

List index out of bounds (1)

Out of curiosity, is this the first message you got in your Toad session? If you get a Toad error and don't close and re-open Toad, you can sometimes get other errors that aren't necessarily related to what you are currently doing but are because of the previous one.

Just don't ask me how I know this. :slight_smile:

On Tue, Feb 7, 2017 at 2:19 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: List index out of bounds (17)

Reply by John Dorlon
I tried nulls also - no problems here.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

--
Phyllis Helton

Data Magician

Security Gestapo
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

I’ve closed toad and tried again. Got the same error

query- select months,days from SYSMAN.MGMT_JOB_SCHEDULE;

error-

List index out of bounds (1)

FYI… I’ve uninstalled my oracle client and reinstalled it (11g x64) to see if it resolves the error but go same error. Any other suggestions?

How to collect trace of this?

How to collect trace of this?

did you see my question about "click here"?

As long as you are reinstalling things - if you don't mind losing your settings in Toad, you could try Utilities -> Copy User Settings, then check "Reset to a clean set of user files" and click OK.

There is no “click here” button on the dialog box

2860.error.jpeg

Thank you! It is working now after I reset the user settings