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 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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.

 

Changes

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. 

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.