Know How To Use ID_NULL Function To Search An Object In Oracle Forms

ID_NULL built in function is used to determine that an object type variable is null or not null in Oracle Forms and returns a BOOLEAN value that indicates whether the object ID is available or not means it is null or not null.

Below is the Syntax of ID_Null function:

FUNCTION ID_NULL
(Objectid);


Where Objectid can be one of the following objects: Alert, Block, Canvas, Editor, FormModule, GroupColumn, Item, LOV, MenuItem, ParamList, RecordGroup, Relation, REPORT_OBJECT, TabPage, Timer, Viewport, VisualAttribute and Window.

Use ID_NULL when you want to check for the existence of an object created dynamically at runtime. For example, if a specific record group already exists, you will receive an error message if you try to create that record group. To perform this check, follow this general process: Use the appropriate FIND_ Built-in to obtain the object ID. Use ID_NULL to check whether an object with that ID already exists. If the object does not exist, proceed to create it.
 
See Examples for ID_NULL with the following link:
 

posted @ 2016-12-25 18:24  全威儒  阅读(279)  评论(0编辑  收藏  举报