Hi Folks,

I've been leading you (and myself) on a wild goose chase. My problem
occurs even when the trigger is disabled.

the problem is as follows:
(StoredProc1 makes use of View1).

execute procedure StoredProc1. result is correct
execute procedure StoredProc1 (again). result is correct
select * from View1. result is correct
execute procedure StoredProc1 (again). result is wrong.

drop view View1.
create view View1. (i.e. re-compile view)
alter procedure StoredProc1 (i.e. recompile procedure)

execute procedure StoredProc1. result is correct

I'm busy stripping down the database to end up with a workable test
case.

regards, Colin