-
Global Variables
Currently, I have this code in 'When_New_Form_instance' in Form Level.
How can i make it global so i can use UN,PW,CN variables in other levels such as block level.
DECLARE
UN VARCHAR2(80);
PW VARCHAR2(80);
CN VARCHAR2(80);
BEGIN
UN := GET_APPLICATION_PROPERTY(USERNAME);
PW := GET_APPLICATION_PROPERTY(PASSWORD);
CN := GET_APPLICATION_PROPERTY(CONNECT_STRING);
Where should i put that code to be global????
-
U can create hidden display items. or u can just assign the values to :global.[variablename] := 'value' . this u can refer at any place and change it.