• An alternative is to use a temp table created by the proc which will be visible to the trigger