D:\oracle\product\10.2.0\db_1>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 13 10:58:35 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdba 已连接。 SQL> create directory user_dir as 'C:\';目录已创建。SQL> grant read on directory user_dir to public;授权成功。SQL> set serverout on SQL> declare 2 lb_exists boolean; 3 ln_file_size number; 4 ln_blocksize number; 5 begin 6 utl_file.fgetattr('USER_DIR','aaa.sql',lb_exists,ln_file_size,ln_blocksize) ; 7 if lb_exists then 8 dbms_output.put_line('File size:'||ln_file_size); 9 else 10 dbms_output.put_line('File is not found!'); 11 end if; 12 end; 13 / File size:22606PL/SQL 过程已成功完成。SQL>
已连接。
SQL> create directory user_dir as 'C:\';目录已创建。SQL> grant read on directory user_dir to public;授权成功。SQL> set serverout on
SQL> declare
2 lb_exists boolean;
3 ln_file_size number;
4 ln_blocksize number;
5 begin
6 utl_file.fgetattr('USER_DIR','aaa.sql',lb_exists,ln_file_size,ln_blocksize)
;
7 if lb_exists then
8 dbms_output.put_line('File size:'||ln_file_size);
9 else
10 dbms_output.put_line('File is not found!');
11 end if;
12 end;
13 /
File size:22606PL/SQL 过程已成功完成。SQL>