Show Alert Username Password Connect_string

GET_APPLICATION_PROPERTY examples 


PROCEDURE Get_Connect_Info( the_username IN OUT VARCHAR2, 
             the_password IN OUT VARCHAR2, 
             the_connect  IN OUT VARCHAR2) IS 
BEGIN the_username := Get_Application_Property(USERNAME); 
 the_password := Get_Application_Property(PASSWORD); 
 the_connect  := Get_Application_Property(CONNECT_STRING); 
END; 

باختصار


declare
eyad number;
 ss varchar2 (250);
pp varchar2 (250);
yy varchar2 (250);
begin ss:=Get_Application_Property(USERNAME);
pp:=Get_Application_Property(password);
yy:= Get_Application_Property(CONNECT_STRING); 
Set_Alert_Property('ALERT46',ALERT_MESSAGE_TEXT,ss||pp||yy); 
eyad:=show_alert('ALERT46');

end;