My Oracle Support Banner

Result Cached PL/SQL Function Using DBLink Returns Incorrect Results (Doc ID 3017480.1)

Last updated on APRIL 30, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Getting incorrect values from result cache if queries using dblinks to fetch results from Remote DB when DBlinks are down or remote db is down.

Below is the simple function using result cache throwing wrong boolean value when trying to fetch value from remote DB which is down:

Now if remote DB up and executing the same function rc_test will always giving same result False from result cache even though query result is true. This behavior happening because of published stuck entry which is not accessing DB_Link and having result as False. 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.