re: obtaining the username for form display

From: blak <blakpawn_at_netcomuk.co.uk>
Date: 1998/02/23
Message-ID: <34f1b0c7.15388682_at_nntp.netcomuk.co.uk>#1/1


[Quoted] [Quoted] I'm having problems obtaining the username so that I can display it in a text field on my form.
I have tried using GET_APPLICATION_PROPERTY(USERNAME), but it gives me the error :
FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception VALUE_ERROR The code I have used is:
DECLARE
        the_username VARCHAR2;
BEGIN

[Quoted] 	the_username := Get_Application_Property(USERNAME); 
	:my_blk.name := the_username;

END; [Quoted] but it doesn't even get as far as assigning the_username to the block item.
Can anyone help? Thanks Received on Mon Feb 23 1998 - 00:00:00 CET

Original text of this message