ORA-25242: cannot change subscriber name from string to string without FIRST_MESSAGE option
What triggered the Error:
attempt was made to change the subscriber name while using the NEXT_MESSAGE or NEXT_TRANSACTION option for dequeuing.What should we do to fix it:
use a subscriber name that is different from the previous dequeue call, reset the dequeuing position by using the FIRST_MESSAGE navigation option.