Unanswered: Database Stored Procedure in Oracle become Invalid
I am using Oracle 9i and want to capture data from Sybase using Oracle Gateway. I have written the Database Stored Procedure, but whenever Gateway is down and I want to run the stroed procedure, it becomes invalid, and so can't run untill or unelss I recompiled it again.
Is there anyway to automatically validate the procedure b4 running it without compiling, which is an efficient way ??