Get_application_property(username).

I put the following code into "When_New_Form_Instance" at Module level but its not working.

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);

if UN = 'Peter' then
set_item_property('BlockName.ItemName',visible,property_false);
END IF;
END;


Whats wrong with that code. Where should i put it?
Why GET_APPLICATION_PROPERTY(USERNAME) is not working (can't get a username)?

Any help please?
Thank you.

What is not working? Are you getting an error code, or no data returned? If nothing returned, try using PETER instead of Peter. If you create a user, the statement can be all lowercase. But, when you want to query for the username in dba_users, for example, you have to query by using all uppercase. I would expect the built-in to act the same way with respect to the username.

Thank you Stecal,

Its working now. It was uppercase proplem.