Re: Determine then name of the DB inside a Stored Procedure

That should be

    select value from sys.v_$parameter where name ='db_name';

Kathy in Philadelphia

Kathleen Foley wrote in message <7unic7$i9c$1_at_elmo.tju.edu>...
>under sys:
> grant select on v_$parameter to <username>;
>
>under <username>
> select value from v_$parameter where name='db_name';
>
>Kathy in Philadelphia
Received on Thu Oct 21 1999 - 12:36:14 CDT