Describing a TYPE returns ORA-24328: illegal attribute value (Doc ID 2243885.1)

Last updated on MARCH 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2 BETA1 and later
Information in this document applies to any platform.

Symptoms

Attempting to DESCRIBE any TYPE object results in the following error

SQL> desc job
ERROR:
ORA-24328: illegal attribute value

METHOD
------
FINAL CONSTRUCTOR FUNCTION JOB RETURNS SELF AS RESULT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
JOB_NAME VARCHAR2 IN
JOB_STYLE VARCHAR2 IN DEFAULT
JOB_TEMPLATE VARCHAR2 IN DEFAULT
PROGRAM_ACTION VARCHAR2 IN DEFAULT
ACTION_TYPE VARCHAR2 IN DEFAULT
SCHEDULE_NAME VARCHAR2 IN DEFAULT
REPEAT_INTERVAL VARCHAR2 IN DEFAULT
EVENT_CONDITION VARCHAR2 IN DEFAULT
QUEUE_SPEC VARCHAR2 IN DEFAULT
START_DATE TIMESTAMP WITH TIME ZONE IN DEFAULT
END_DATE TIMESTAMP WITH TIME ZONE IN DEFAULT
NUMBER_OF_ARGS UNDEFINED IN DEFAULT
ARGUMENTS JOBARG_ARRAY IN DEFAULT
JOB_CLASS VARCHAR2 IN DEFAULT
SCHEDULE_LIMIT INTERVAL DAY TO SECOND IN DEFAULT
PRIORITY UNDEFINED IN DEFAULT
JOB_WEIGHT UNDEFINED IN DEFAULT
MAX_RUN_DURATION INTERVAL DAY TO SECOND IN DEFAULT
MAX_RUNS UNDEFINED IN DEFAULT
MAX_FAILURES UNDEFINED IN DEFAULT
LOGGING_LEVEL UNDEFINED IN DEFAULT
RESTARTABLE BOOLEAN IN DEFAULT
STOP_ON_WINDOW_EXIT BOOLEAN IN DEFAULT
RAISE_EVENTS UNDEFINED IN DEFAULT
COMMENTS VARCHAR2 IN DEFAULT
AUTO_DROP BOOLEAN IN DEFAULT
ENABLED BOOLEAN IN DEFAULT
FOLLOW_DEFAULT_TZ BOOLEAN IN DEFAULT
PARALLEL_INSTANCES BOOLEAN IN DEFAULT
AQ_JOB BOOLEAN IN DEFAULT
INSTANCE_ID UNDEFINED IN DEFAULT

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms