PL/SQL (MOSC)

MOSC Banner

Edition based redifinition , using pipelined function , alter table produces ORA-04043

edited Aug 7, 2019 3:40AM in PL/SQL (MOSC) 5 commentsAnswered ✓

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center