PLS-00306: Wrong Number or Types of Arguments in Call to 'LIMIT' When Trying to Use LIMIT with Associative Array
(Doc ID 1354955.1)
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 10.2.0.1 to 22.214.171.124 - 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document