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

PCC-02308: identifier required in this function declaration

1 Answers  


ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.

1 Answers  


ORA-38473: cannot drop a type used for Expression Filter attribute set

1 Answers  


ORA-00446: background process started when not expected

1 Answers  


NNO-00624: setting auto-refresh expiration period to number seconds

1 Answers  


ORA-16084: an apply engine is already running

1 Answers  


PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression

1 Answers  


PLS-00203: function DECODE must be called with at least 3 non-boolean arguments

1 Answers  


ORA-29371: pending area is not active

1 Answers  


ORA-32341: The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"

1 Answers  


ORA-25261: JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation

1 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  


Categories