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

under sys:

    grant select on v_$parameter to <username>;

under <username>

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

Kathy in Philadelphia

Rui Anastácio wrote in message <7un4f3$3gq$1_at_duke.telepac.pt>...
>I have a procedure that writes a file to the system via utl_file. Since I
>have to indicate the directory and this changes from development to test
and
>production I need to change the Stored Procedure upon compiling in
different
>DB's (the problem).
>
>I could solve the problem if I knew the database name from the procedure.
>Then I could write the file to the corresponding place.
>
>USERENV might be a solution
>V$ is for SYS only right ?
>DBMS_APPLICATION_INFO might do it but I don't have the info. Anyone ?
>
>Any other way ?
>
>
>
>
>
Received on Thu Oct 21 1999 - 12:30:31 CDT