Edition based redifinition , using pipelined function , alter table produces ORA-04043
We recently enabled EBR feature on our 11.2.0.4 database (no patches installed) . We have some problems with errors like ORA-04043: object SYS_PLSQL_XXX does not exist
It seems , they are connected with usage of pipelined functions
I have reproduced one case.
I have created a table and package with pipelined function using the table
I created a new edition and set my session to use it
I added column to the table , than recompiled the package , tried to add another column and I got ORA-04043: object SYS_PLSQL_XXX does not exist(XXX depends on object_id of package in original edition)