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-02467: Column referenced in expression not found in cluster definition

1 Answers  


ORA-13856: Service name must be specified

1 Answers  


PCC-02401: Host variable arrays of this type are currently not supported

1 Answers  


TNS-00206: Status Information for Interchange string:

1 Answers  


ORA-37014: (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.

1 Answers  






ORA-14513: partitioning column may not be of object datatype

1 Answers  


ORA-36961: Oracle OLAP is not available.

1 Answers  


ORA-28552: pass-through SQL: call flow error

1 Answers  


ORA-09832: infoCallback: bad message format.

1 Answers  


AMD-00113: PROCEDURE string, invalid operation

1 Answers  


TNS-00556: no method specified for wallet retrieval

1 Answers  


PLS-00122: %s as separator is allowed only with specific built-in functions

1 Answers  


Categories