Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

Dbms_utility get_parameter_value

SQL> SQL> declare   2    l_intval number;   3    l_strval varchar2(2000);   4    l_type   number;   5    begin   6       l_type := dbms_utility.get_parameter_value('user_dump_dest', l_intval, l_strval);   7       dbms_output.put_line(l_strval );   8    end;   9  / C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP PL/SQL procedure successfully completed. SQL> SQL>