Oracle DB Error ORA-24051 cannot propagate object type payloads that have a REF or BFILE attribute

The following is the cause of this error:

An ADD_SUBSCRIBER or ENQUEUE procedure with a non-NULL address field in the agent type was issued on a queue whose payload has a REF or BFILE attribute. Propagation of object type payloads that have a REF or BFILE attribute currently is not supported.

Action you can take to resolve this issue: Specify an agent with a NULL address field so that the agent can dequeue from the same queue. Or, change the object type definition to one that does not use REF or BFILE attributes.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related