How to fix the Oracle error PGU-35007: failure to fetch for cursor string statement string: rc string?

In this post, you’ll learn more about the Oracle ErrorPGU-35007: failure to fetch for cursor string statement string: rc string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGU-35007: failure to fetch for cursor string statement string: rc string

Reason for the Error PGU-35007: failure to fetch for cursor string statement string: rc string

Cause: Fetch using Oracle cursor PGAU SQL statement failed with Oracle error . Possible error in PGAU GENERATE statement transaction or version parameters, or possible missing rows or misspelled in the PG DD for the requested transaction. This message is preceded by an Oracle Server message for the specific error encountered.

How to fix the Error PGU-35007: failure to fetch for cursor string statement string: rc string ?

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

Action: Ensure the Oracle server supporting the PG DD is active. Check that all call, data, and attribute definitions associated with the requested transaction and version are properly defined in the PG DD. If the error persists, reproduce the error with tracing enabled. Supported customers should contact Oracle Worldwide Support for assistance.