SQL>
SQL> declare
2 intval number;
3 strval varchar2(512);
4 begin
5 if ( dbms_utility.get_parameter_value( 'utl_file_dir',intval,strval ) = 0 )
6 then
7 dbms_output.put_line( 'Value = ' || intval );
8 else
9 dbms_output.put_line( 'Value = ' || strval );
10 end if;
11 end;
12 /
Value = 0
PL/SQL procedure successfully completed.
SQL>