Re: Accessing the Databse name with pl/sql

1. You need to set priviledges to the schema where you are to create your stored procedure:

grant select on V_$DATABASE to user1;

2) create the SP or function like this:

Create Or Replace Function Db_Name
Is
Db_N Varchar2(10);
Begin
Select Name Into Db_N From Sys."V_$DATABASE"; Return Db_N;
End;
/

--
Posted via http://dbforums.com