How to fix the Oracle error JMS-00242: Illegal attempt to enqueue message with both immediate visibility and three phase enqueue process.?

In this post, you’ll learn more about the Oracle ErrorJMS-00242: Illegal attempt to enqueue message with both immediate visibility and three phase enqueue process. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

JMS-00242: Illegal attempt to enqueue message with both immediate visibility and three phase enqueue process.

Reason for the Error JMS-00242: Illegal attempt to enqueue message with both immediate visibility and three phase enqueue process.

Cause: Illegal attempt to enqueue message with both immediate visibility and three phase enqueue process.

How to fix the Error JMS-00242: Illegal attempt to enqueue message with both immediate visibility and three phase enqueue process. ?

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

Action: turn on the system property oracle.jms.useTemplobsForEnqueue