Retrieve the local file size.
| Examples |
SET SERVEROUTPUT ON SIZE 1000000;
DECLARE
ln_before_sz NUMBER := 0;
lv_local_file VARCHAR2(255) := 'c:\winnt\notepad.exe';
BEGIN
ln_before_sz := fclient_p.localfilesize(lv_local_file);
DBMS_OUTPUT.PUT_LINE('Local File Size (bytes): '||ln_before_sz);
EXCEPTION
WHEN fclient_p.java_failed THEN
DBMS_OUTPUT.PUT_LINE(SUBSTR(fclient_j.getErrorMessage, 1, 255));
END;
/
Output from example above:
Local File Size (bytes): 50960
© 1999-2003 Bear Claw Inc.