DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Global Variables

  1. #1
    Join Date
    Jul 2002
    Posts
    24

    Question 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????

  2. #2
    Join Date
    Aug 2002
    Posts
    3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width