Re: Why my procedure becomes invalid again & again ?

From: Louise Miller <miller_at_louise.ucsd.edu>
Date: 1996/01/25
Message-ID: <1996Jan25.193734.18999_at_nosc.mil>#1/1

vkj_at_ctt.bellcore.com (Vinod Jain) wrote:
>Hi,
>
>We have a strange problem at our client site. There are some stored
>procedures which become INVALID automatically, even if there are no changes
>in underlying tables, permissions etc. This problem keeps coming every few
>weeks and the client has to recompile it every time.
>
>Any clues to this problem ?
>Thanks
>Vinod Jain

Could there be a synonym which is changing? That will cause the procedure to need a recompile.
Louise Miller Received on Thu Jan 25 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Kingsley Idehen: "Re: Connecting to Oracle via ODBC and MS Access"
Previous message: Lawrence James: "Re: Novel scenario of trigger mutation - take a look"
In reply to: Vinod Jain: "Why my procedure becomes invalid again & again ?"
Next in thread: Willy Klotz: "Re: Use index for order by ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message