How to fix the Oracle error PCC-00143: Runtime context variable not of correct type?

In this post, you’ll learn more about the Oracle ErrorPCC-00143: Runtime context variable not of correct type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00143: Runtime context variable not of correct type

Reason for the Error PCC-00143: Runtime context variable not of correct type

Cause: The runtime context variable referecned in an EXEC SQL CONTEXT USE statement is not of type sql_context.

How to fix the Error PCC-00143: Runtime context variable not of correct type ?

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

Action: Declare your runtime context variable of type sql_context.