Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOB , 10 of 26
This function finds out if a given BFILE
locator points to a file that actually exists on the server's filesystem.
DBMS_LOB.FILEEXISTS ( file_loc IN BFILE) RETURN INTEGER;
pragma restrict_references(FILEEXISTS, WNDS, RNDS, WNPS, RNPS);
Parameter | Description |
---|---|
file_loc |
Locator for the |
Return | Description |
---|---|
0 |
Physical file does not exist. |
1 |
Physical file exists. |
CREATE OR REPLACE PROCEDURE Example_7 IS fil BFILE; BEGIN SELECT f_lob INTO fil FROM lob_table WHERE key_value = 12; IF (dbms_lob.fileexists(fil)) THEN ; -- file exists code ELSE ; -- file does not exist code END IF; EXCEPTION WHEN some_exception THEN handle_exception; END;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|