Got it working - the reconfigure didn't take effect.
I am struggling to get an insert trigger to fire. I have a parent child relationship with an insert into the parent table triggering the insert into the child table. The trigger on the parent table doesn't fire. The data in the parent table is populated from another trigger.
I have currently got nested triggers switch off but have tested with nested triggers on with no effect.
When I manually run the insert statement below, everything is OK and child records created.
PS. I'm still a bit of a noob at this SQL stuff and any help is appreciated. Thanks