Re: Forms 4.5 question

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Wed, 16 Sep 1998 18:37:39 +0200
Message-ID: <6tope9$9ik$1_at_sunrise.pg.gda.pl>

Lisa F. Miller wrote in message <35FFE526.47BE1E30_at_ornl.gov>...
>Does anyone out there know anything about the built-in substitution
>parameters?
>
>I have need to reference one of these from a trigger (for example, UN -
>Current Username), but am unable to get this to compile:
>"message('Current User is : ' || :UN);" - get message "bad bind variable
>'UN' ". Any help would be greatly appreciated.
>

You probably think about :un, :pw, :tt predefined variables in SQL*Menu 5.
With Forms 4.5 and above there are no longer such variables. We can obtain username, password and connect string via get_application_property.

declare

 a_un      varchar2(30);
 a_pswd    varchar2(30);
 a_cstring varchar2(80);
begin
  a_un:=     get_application_property(USERNAME);

  a_pswd:= get_application_property(PASSWORD);   a_cstring:= get_application_property(CONNECT_STRING); ...
exception
...
end;

HTH,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Wed Sep 16 1998 - 18:37:39 CEST