SQL-02147: ANSI Dynamic occurrence value out of range



SQL-02147: ANSI Dynamic occurrence value out of range..

Answer / guest

Cause: The value clause in a dynamic GET or SET statement is
less than one or greater than MAX given for descriptor
allocation.

Action: Supply a number for the VALUE clause between 1 and
the MAX occurrences supplied when the descriptor was allocated.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12710: CREATE CONTROLFILE character set is not known

1 Answers   Orange,


ORA-09218: sfrfs: failed to refresh file size

1 Answers  


ORA-01262: Stat failed on a file destination directory

1 Answers  


ORA-22316: input type is not a collection type

1 Answers  


ORA-31627: API call succeeded but more information is available

1 Answers  


ORA-25127: RELY not allowed in NOT NULL constraint

1 Answers  


ORA-07220: slspool: wait error.

1 Answers  


ORA-09743: smscre: could not attach shared memory.

1 Answers  


ORA-33098: (APABBR01) A value of 'string' is not valid for the workspace object option.

1 Answers  


QSM-01046: complex join back on correlated columns not allowed (string)

1 Answers  


ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

1 Answers  


LPX-00309: cannot initialize XPATH

1 Answers  


Categories