> > Does this procedure selects from another procedures ?
>
> Yes it does. And it updates tables which will fire triggers which will
> select from other procedures...

Try to recompile (alter to itself) all procedures on which "bad" procedure
depends. After recompile "bad" procedure too. Some tools (IBE for example)
allows to do it automatically.

Regards,
Vlad