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

QSM-01509: equivalence, string, matched query text

1 Answers  


IMG-00714: internal error

1 Answers  


CLSR-00525: prsr initialization failed

1 Answers  


AUD-00809: ORDSpeechIndex: unable to ALTER REBUILD internal Text index

1 Answers  


DRG-11000: invalid keyword string

1 Answers  






ORA-29858: error occurred in the execution of ODCIINDEXALTER routine

1 Answers  


ORA-09877: sstascre: shmget error, unable to get a shared memory segment.

1 Answers  


ORA-02155: invalid DEFAULT tablespace identifier

2 Answers  


ORA-24095: invalid transformation, source type does not match that of the queue

1 Answers  


EXP-00082: Invalid function name passed to procedural object support: string

1 Answers  


SQL-02137: Multi-threaded agent with no RETURNING clause present

1 Answers  


IMP-00099: Warning: The typeid in the dump file for object type "string"."string" is invalid

1 Answers  


Categories