PL/SQL (MOSC)

MOSC Banner

Schema mane automatically appended to call from functions/procedures

edited Apr 2, 2020 5:02AM in PL/SQL (MOSC) 3 commentsAnswered

 
I have a few functions in my database that calls other functions under the same schema, For example  MYFUNCTION under MYSCHEMA schema includes a call to MYSCHEMA.MYFUNCTION2().
 
The functions have been working correctly until recently. Now these functions return an invalid stage and it seems like the compiler is appending the schema name by default. The error message is object  MYAPEXSCHEMA.MYAPEXSCHEMA is invalid.
 
If I change the call  in MYFUNCTION() from MYSCHEMA.MYFUNCTION2() to MYFUNCTION2() the function MYFUNCTION() will compile and run without issues
 
Does anyone know what is causing this behaviour?

Thanks

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