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>