My Oracle Support Banner

GET_ITEM_PROPERTY (ITEM, DATABASE_VALUE) Returns Wrong Value (Doc ID 1678904.1)

Last updated on APRIL 25, 2023

Applies to:

Oracle Forms - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

The builtin GET_ITEM_PROPERTY (item, DATABASE_VALUE) returns the wrong value if that item has a changed uncommitted value. This is incorrect according the online guide which states

 

For a base table item that is part of a database record whose status is QUERY or UPDATE, Database_Value returns the value that was originally fetched from the database. When a fetched value has been updated and then subsequently committed, Database_Value returns the committed value.

In this case the returned value is the changed "uncommitted" value.

 

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.