Hi, As we have a global variable value concept exist in oracle form where store value and can be used throughout the application. I am also looking the same way in application, so i can used it anywhere in application. Thanks.
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Hi, As we have a global variable value concept exist in oracle form where store value and can be used throughout the application. I am also looking the same way in application, so i can used it anywhere in application. Thanks.
Dear Vinish,
Thanks for you quick reply on this, Hence issue got resolved.
I would like to appreciate your efforts on this issue as you have guided in very sample way.
Thanks.
You can assign a value to a global variable at any point in Oracle Forms, and when you set a value, it got created and can be accessed in any form.
Syntax of a global variable:
For example, in the very first form of your application, you can create a global variable by assigning a value and access it throughout your application.
Thanks for the update.
Sorry, i missed on point which forgot to mentioned, Actually this global/session variable i have to assign in apex.
Can you please guide or refer some example which help me using this variable in oracle Apex application.
Thanks.
Ok, in Oracle Apex, you can use application items.
You will find this option in shared components > Application Items.
Click this option, then create an application item, for example:
MY_APPITEM
After creating it, you can use this item in your application. To assign a value to an application item, check the following examples:
apex_util.set_session_state('MY_APPITEM', 'a value');apex_util.set_session_state('MY_APPITEM', :P1_ITEM);To read the value from it, check the following examples:
In PL/SQL:
Begin if :MY_APPITEM = 'A' then null; end if; End;Can it be set only from PL/SQL or from javascript too?
I have tried with $v(“MYITEM”, “a value”) but it doesn’t work
The $v() function is to get the value, to set the value use $s(), below is the example:
$s('MY_ITEM', 'A VALUE');Oh but yes, with the application item it will not work. You will have to use the PL/SQL apex_util.set_session_state() procedure.