My Oracle Support Banner

Use Of Local Collection Types Is Not Allowed in SQL Statements. (Doc ID 208763.1)

Last updated on APRIL 21, 2022

Applies to:

PL/SQL - Version 8.1.7.4 and later
Information in this document applies to any platform.

Symptoms

* PLS-00642: local collection types not allowed in SQL statements
* ORA-06550: line %s, column %s:\n%s
* ORA-00932: inconsistent data types

Changes

Attempt to insert locally defined varray type as follows:


Error:

insert into my_table values(local_varray);
                                  *
ERROR at line 7:
ORA-06550: line 7, column 31:
PLS-00642: local collection types not allowed in SQL statements
ORA-06550: line 7, column 31:
PL/SQL: ORA-00932: inconsistent datatypes
ORA-06550: line 7, column 3:
PL/SQL: SQL Statement ignored

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.