How to fix the Oracle error PGU-41126: WITH token immediately followed by another WITH token?

In this post, you’ll learn more about the Oracle ErrorPGU-41126: WITH token immediately followed by another WITH token with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGU-41126: WITH token immediately followed by another WITH token

Reason for the Error PGU-41126: WITH token immediately followed by another WITH token

Cause: There are two succesive WITH tokens in the command input stream.

How to fix the Error PGU-41126: WITH token immediately followed by another WITH token ?

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

Action: Insert DATA or CALLS after the WITH token depending on which type of referenced objects should also be UNDEFINEd or REPORTed.