Database Administration (MOSC)

MOSC Banner

invalid function (11.2)

edited Oct 17, 2012 9:02PM in Database Administration (MOSC) 4 commentsAnswered
Hello all

Here is my situation. There is a function with invalid status because a table that is referenced in the function does not exist.  This function is executed in a batch script. The previous step in that script is to create the missing table (the table is being dropped at the end of the script). Does oracle attempt to recompile a function before executing it? Based on the quick test that I did it looks like it does, but I  would like to hear from soeone who can confirm  that this is indeed the case

thank you

Gene

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