HI, i have a problem with Oracle SP.....

[somaiyatushar11]

i have a simple SP which gives me information from 5 different tables... This SP compiles successfully... But sometimes SP gets dropped automatically.. or i don't know what happens but i have to recompile it and then execute it...this happens very regularly....

i don't know if anything is wrong with the SP or server settings or what.. because other 40 SPs run fine. i have this peculier problem with this SP only...

if anybody knows why this happens or / and how to solve it then please let me know. if required i can send the SP code to you....

 

[DaPi]

The SP will need recompiling whenever tables or views it depends on are changed or when a SP it calls changes.

 

[somaiyatushar11]

My SP does not call any other SP nor i am changing the underlying tables....

The problem occurs uncanningly...