PLS-00801 Illegal Datatype Error When Using '.' (dot) Notation For Variables In PL/SQL.
(Doc ID 2424425.1)
Last updated on APRIL 03, 2025
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 |