invalid function (11.2)
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