Re: instance_name as unprivileged user

On Wed, 21 Dec 2005 01:21:20 -0800, sybrandb_at_yahoo.com wrote:

> declare
> str_len number;
> str varchar2(30);
> begin
> dbms_utility.get_parameter_value('db_name', str_len, str);
> end;
> /

This will not work. On oracle10, the only version which has INSTANCE_NAME as a parameter, GET_PARAMETER_VALUE is declared as a function which returns binary integer.

FUNCTION GET_PARAMETER_VALUE RETURNS BINARY_INTEGER

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PARNAM                         VARCHAR2                IN
 INTVAL                         BINARY_INTEGER          IN/OUT
 STRVAL                         VARCHAR2                IN/OUT
 LISTNO                         BINARY_INTEGER          IN     DEFAULT

On Oracle 10g, this would work a bit better:

declare
str_len number;
ivl integer;
str varchar2(30);
res integer;
begin
res:=dbms_utility.get_parameter_value('instance_name', ivl, str); dbms_output.put_line('Instance_name:'||str); end;
/

-- 
http://www.mgogala.com