ORA-29254: Invalid lower_bound argument passed to procedure dbms_sql.define_ array

ORA-29254: Invalid lower_bound argument passed to procedure dbms_sql.define_ array

Cause: The lower_bound argument specified in the call to procedure define_array had an invalid value. Legal values are all integers (both positive and negative) including zero. The null value is illegal.

Action: Correct your PL or SQL program so that only valid arguments are passed to define_array and try again.

ORA-29253: Invalid count argument passed to procedure dbms_sql.define_array

ORA-29253: Invalid count argument passed to procedure dbms_sql.define_array

Cause: The count argument specified in the call to procedure define_array of package dbms_sql had an invalid value. Invalid values are negative numbers and nulls. The argument must be a positive integer.

Action: Correct your PL or SQL program so that only valid arguments are passed to define_array and try again.

ORA-29252: collection does not contain elements at index locations in call to dbms_ sql.bind_array

ORA-29252: collection does not contain elements at index locations in call to dbms_ sql.bind_array

Cause: The bound table does not contain elements at both index locations in call to bind_array of dbms_sql. This is illegal. Both index locations must contain elements. In other words tab.exists(index1) and tab.exists(index2) must both return true.

Action: Either modify the two indexes or the contents of the table and try the call again.

ORA-29251: Index1 is greater than Index2 in call to dbms_sql.bind_array

ORA-29251: Index1 is greater than Index2 in call to dbms_sql.bind_array

Cause: The value of index1 was greater than the value for index2 in the call to bind_array. This is illegal since the elements of the table that will be bound are those with indexes greater than or equal to index1 and less than or equal to index2.

Action: Correct the value of the two indexes and try the call to again bind_array.

ORA-29250: Invalid index specifed in call to dbms_sql.bind_array

ORA-29250: Invalid index specifed in call to dbms_sql.bind_array

Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value.

Action: Correct the index value by modifying your PL or SQL program and try the bind_array call again.

ORA-28674: cannot reference transient index-organized table

ORA-28674: cannot reference transient index-organized table

Cause: An attempt was made to directly access a transient table created created on behalf of a index-organized table partition maintenance operation.

Action: Issue the statement against the associated permanent index-organized table.

ORA-28673: Merge operation not allowed on an index-organized table

ORA-28673: Merge operation not allowed on an index-organized table

Cause: User attempted merge operation on an index-organized table. Merge is not supported on a IOT .

Action: Use updates and inserts on index-organized table .