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!

What is the difference between index by pls_integer and index by binary_integer for a collection?

MichaelRAug 12 2013 — edited Aug 13 2013

Hello Everyone,

I've having some difficulty to understand the difference between pls_integer and binary_integer when declaring a collection..

Isn't both pls_integer and binary_integer supposed to be the same in 10g and 11g?

My problem is that i've declared a collection in a procedure with binary_integer and per record it takes 10second to process. (i.e TYPE test_table IS TABLE OF test%rowtype INDEX BY BINARY_INTEGER; )

However the same procedure with the collection declared with index by pls_integer, take only 1 second to process. (i.e TYPE test_table IS TABLE OF test%rowtype INDEX BY PLS_INTEGER;)

Any help would be welcomed.

Thanks.

This post has been answered by Billy Verreynne on Aug 13 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2013

Added on Aug 12 2013

#plsql

8 comments

8,445 views