My Oracle Support Banner

Column Alias Is Not Honored in the Result Set from Pipeline Function in 18c (Doc ID 2517404.1)

Last updated on DECEMBER 19, 2019

Applies to:

PL/SQL - Version 12.2.0.1 and later
Generic (Platform Independent)

Symptoms

A pipeline function that fetches record from a cursor associated with a SQL statement having column alias used, doesn't display the original column alias in the result set. Rather, it shows the column heading as 'ATTR_n'(where n is the number of columns displayed).

Changes

Database is upgraded to version 18.0.0.0. It works absolutely fine till 12.2.0.1.

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.