Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOB , 12 of 26
This function finds out whether a BFILE
was opened with the given FILE
locator.
If the input FILE
locator was never passed to the FILEOPEN
procedure, then the file is considered not to be opened by this locator. However, a different locator may have this file open. In other words, openness is associated with a specific locator.
DBMS_LOB.FILEISOPEN ( file_loc IN BFILE) RETURN INTEGER;
pragma
restrict_references
(FILEISOPEN,WNDS
,RNDS
,WNPS
,RNPS
);
Parameter | Description |
---|---|
file_loc |
Locator for the |
INTEGER
: 0 = file is not open, 1 = file is open
CREATE OR REPLACE PROCEDURE Example_9 IS DECLARE fil BFILE; pos INTEGER; pattern VARCHAR2(20); BEGIN SELECT f_lob INTO fil FROM lob_table WHERE key_value = 12; -- open the file IF (dbms_lob.fileisopen(fil)) THEN pos := dbms_lob.instr(fil, pattern, 1025, 6); -- more file operations dbms_lob.fileclose(fil); ELSE ; -- return error END IF; END;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|