In this post, you’ll learn more about the Oracle ErrorPLS-00249: Invalid WITH CONTEXT Syntax with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00249: Invalid WITH CONTEXT Syntax
Reason for the Error PLS-00249: Invalid WITH CONTEXT Syntax
CONTEXT was used in a WITH CONTEXT or a PARAMETERS clause. This is invalid.
How to fix the Error PLS-00249: Invalid WITH CONTEXT Syntax ?
You can fix this error in Oracle by following the below steps
Check if WITH CONTEXT is used without specifying CONTEXT in the PARAMETERS clause or vice versa. The PARAMETERS clause must be complete. Thus if WITH CONTEXT is specified, then CONTEXT must be referenced in the PARAMETERS clause (if there is one).