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 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

When trying to use LIMIT on a PL/SQL associative array using the following code:

DECLARE
   TYPE aa_type IS TABLE OF INTEGER INDEX BY varchar2(10);
   aa aa_type; -- associative array
BEGIN
   aa(1):=3; aa(2):=6; aa(3):=9; aa(4):= 12;
   DBMS_OUTPUT.PUT_LINE('aa.LIMIT = ' || aa.LIMIT);
END;

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
.

Cause

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