Subject Re: Global Temporary Tables are transaction specific
Author robert.gilland
Found the answer:

I needed to add

ON COMMIT PRESERVE ROWS

to the end of the create table statement now all good.

sweet.