My Oracle Support Banner

Pipeline Function Returning UDT Defined in the Package Specification Raises ORA-00902 Post Database Upgrade to 18c (Doc ID 2696498.1)

Last updated on APRIL 17, 2023

Applies to:

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


A pipeline function returning UDT defined in the package specification works fine till RDBMS version 12c Release 2. The invocation of the same function fails with "ORA-00902: invalid datatype" error after upgrading the database to 18c or any other latest version. For example, the following code works across the RDBMS versions from 11gR2 to 12cR2.



The function is executed for the first time after upgrading the database to 18c or it is compiled and executed on a newly installed 18c database. 


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.