username and service name

[ales]

This could help you:

declare
  dbname global_name.global_name%type;
begin
  select global_name into dbname from global_name;
  dbms_output.put_line(user);
  dbms_output.put_line(dbname);
end;

Ales