At 12:50 PM 07-11-02 +1300, you wrote:

>Arr...
>
>Just found that by changing the trigger that calls the stored procedure,
>it all of a sudden started to use the new stored procedure.
>
>Very confusing... I guess the trigger somehow keeps a link to the old
>procedure??

Yup. Triggers are compiled code too. It always a good idea to examine the
dependencies of things when you change them.

>Just tried changing the stored proc again, and indeed, without changing
>the trigger, the old one still gets called, change the trigger (to be
>the same) and hey presto, the new stored proc gets called.

:-)) Now you know.

h.