Hello
I have test case:
create or replace package test_pack as
cursor cur (aclient_route number)
is
select aclient_route as num_route from dual;
type res is table of cur%rowtype;
function get_exit_auto(aclient_route number) return res pipelined;
end;
create or replace package body test_pack as
function get_exit_auto(aclient_route number) return res pipelined as
begin
for rec in cur (aclient_route)
loop
pipe row (rec);
end loop;
end;
end;
if I select in 11.2.0.2, have result:
select * from table(test_pack.get_exit_auto(1));
NUM_ROUTE
---------
1
if I select in 19.3c, have result:
select * from table(test_pack.get_exit_auto(1));
ATTR_1
------
1
Why 19.3c "result synonym" (NUM_ROUTE/ATTR_1) different?
Many thanks