I put the following code into "When_New_Form_Instance" at Module level but its not working.
UN := GET_APPLICATION_PROPERTY(USERNAME);
PW := GET_APPLICATION_PROPERTY(PASSWORD);
CN := GET_APPLICATION_PROPERTY(CONNECT_STRING);
if UN = 'Peter' then
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?
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.
Click Here to Expand Forum to Full Width