My Oracle Support Banner

PLS-00801 Illegal Datatype Error When Using '.' (dot) Notation For Variables In PL/SQL. (Doc ID 2424425.1)

Last updated on FEBRUARY 19, 2019

Applies to:

PL/SQL - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, PL/SQL. Creating a type object or running a PL/SQL code that uses '.' (dot) notation for variables is resulting in below error. Replacing the '.' (dot) with ',' (comma) resolves the issue. This behavior is specific to 12.1.0.x and does not reproduce in 11.2.0.4 or 12.2.0.x versions. Here are some sample codes that could result in such error. 

Creating TYPE object(s) as below:

 

Changes

Database Upgraded From 11.2.0.4 to 12.1.0.x

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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