Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

get_item_property - database_value - possible bug?

789736Apr 25 2013 — edited Apr 25 2013
Hi guys

Quick question for you. I am using the following in my form:

If nvl(GET_ITEM_PROPERTY(blk.item',DATABASE_VALUE), 'N') = 'N' and name_in('blk.item') = 'Y'
THEN
...
....
end if;

However, under certain scenarios the record may not have been created yet to retrieve the datbase value. I thought under this scenario it would return 'N' but it appears to be returning 'Y' if no record exists. Is this intended and if so does anyone know any ways round this?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2013
Added on Apr 25 2013
4 comments
2,442 views