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!

How to check variable if present or not ?

user452402Jan 25 2007 — edited Jan 25 2007
I have a main form and put the :global.gdate, When I call the others form
I want to use the :global.gdate.

I wirte a trigger "when new form instance" for each form (except main form) so I can get :global.date.

But I can only running this program from main form, if I am running the form without the main form, the error message :global.gdate does not exists.

Question:
-------------------
Is it posible to check if :global.gdate is exists or not ?

maybe somthing like :
------------------------------
IF get_variable(:global.gdate) IS NULL THEN --?????????
:global.gdate := sysdate;
END IF;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2007
Added on Jan 25 2007
5 comments
1,448 views