How to fix the Oracle error PCB-00502: This statement can only be used with THREADS=YES?

In this post, you’ll learn more about the Oracle ErrorPCB-00502: This statement can only be used with THREADS=YES with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCB-00502: This statement can only be used with THREADS=YES

Reason for the Error PCB-00502: This statement can only be used with THREADS=YES

Cause: EXEC SQL ENABLE THREADS has been used, even though option THREADS is set to NO.

How to fix the Error PCB-00502: This statement can only be used with THREADS=YES ?

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

Action: Specify option THREADS=YES or remove the EXEC ENABLE THREADS statement from the source code. “525 – 549, Result Set Cursors”