SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

numeric overflow in PL/SQL tables

117474Apr 4 2002

I have a stored procedure in Oracle 8.0.5 which uses PL/SQL TABLE indexed by BINARY_INTEGER.
The table does not have values continuously. I get "ORA-01426, numeric overflow" exception when the array subscript (the table's size) exceeds a particular value.
Is there any limitation for Binary Integer indexed PL/SQL TABLES?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2002

Added on Apr 4 2002

5 comments

527 views