Is it possible to publish an erratum in another journal?
What can be published in a journal is up to the editors. If the original was sufficiently important and the errors less than obvious to readers, then an editor might consider it. But they would rather, I surmise, publish a full paper with correct results, citing the old, than just an errata. If you can't make the new work seem significant, I doubt that editors would be interested.
But the editor decides, perhaps with advice from reviewers. You can possibly make a proposal to an editor before spending wasted effort.