PLS-00306: Wrong Number or Types of Arguments in Call to 'LIMIT' When Trying to Use LIMIT with Associative Array
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 10.2.0.1 to 126.96.36.199 - Release: 10.2 to 11.2
Information in this document applies to any platform.
TYPE aa_type IS TABLE OF INTEGER INDEX BY varchar2(10);
aa aa_type; -- associative array
aa(1):=3; aa(2):=6; aa(3):=9; aa(4):= 12;
DBMS_OUTPUT.PUT_LINE('aa.LIMIT = ' || aa.LIMIT);
resulted in the following error:
ERROR at line 7:
ORA-06550: line 7, column 46:
PLS-00306: wrong number or types of arguments in call to 'LIMIT'
ORA-06550: line 7, column 5:
PL/SQL: Statement ignored
The modified was from the code provided in the
Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2), LIMIT Collection Method.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms