How to fix the Oracle error ORA-26923: cannot configure string outbound server “string” with string capture “string” due to different purpose?

In this post, you’ll learn more about the Oracle ErrorORA-26923: cannot configure string outbound server “string” with string capture “string” due to different purpose with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26923: cannot configure string outbound server “string” with string capture “string” due to different purpose

Reason for the Error ORA-26923: cannot configure string outbound server “string” with string capture “string” due to different purpose

An attempt was made to configure an outbound server with a capture used for different purpose.

How to fix the Error ORA-26923: cannot configure string outbound server “string” with string capture “string” due to different purpose ?

You can fix this error in Oracle by following the below steps

Execute the following: 1) Get the purpose of each capture and its associated queue: SELECT capture_name, queue_owner, queue_name, purpose FROM dba_capture; 2) Resubmit the statement using a queue or capture with the same purpose.