username and service name

hai

inside the pl/sql procedure,

i need to find schemaowner name and the service name

of the oracle server

This could help you:

Code:

---

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