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 184.108.40.206 to 220.127.116.11 [Release 12.1]
Information in this document applies to any platform.
On : 18.104.22.168 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 22.214.171.124 or 12.2.0.x versions. Here are some sample codes that could result in such error.
Creating TYPE object(s) as below:
Database Upgraded From 126.96.36.199 to 12.1.0.x
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