Stored Procedure requires compilation before every run....
I have one simple SP in Oracle 8. It gets complied very nicely. But after i execute that SP, its defination from the database is lost. I again have to compile and execute it. This means that everytime i have to execute this SP i have first compile....
I can't understand why this is happening??? IIf anybody knows how this can be solved then plz let me know...