My Oracle Support Banner

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


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

   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;

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.