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-01028: internal two task error

1 Answers  


RMAN-06438: error executing package DBMS_RCVMAN in string database

1 Answers  


IMG-00518: invalid value for height or width

1 Answers  


ORA-30502: system triggers cannot have INSERT, UPDATE, or DELETE as triggering events

1 Answers  


ORA-01157: cannot identify/lock data file string - see DBWR trace file

1 Answers  






PCC-02422: Invalid value specified for the given context option

1 Answers  


NID-00420: Change of database name and ID failed during validation - database is intact.

1 Answers  


TNS-00294: Connection Manager: Security is enabled, you cannot STOP the Interchange

1 Answers  


ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

1 Answers  


TNS-00248: Unable to get information from file :string: Exiting with NR error:number

1 Answers  


ORA-38722: ON or OFF expected.

1 Answers  


ORA-39704: permission to modify component registry entry denied

1 Answers  


Categories