Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOB , 9 of 26
This procedure closes all BFILEs
opened in the session.
DBMS_LOB.FILECLOSEALL;
Exception | Description |
---|---|
UNOPENED_FILE |
No file has been opened in the session. |
CREATE OR REPLACE PROCEDURE
Example_6 IS
fil BFILE;
BEGIN
SELECT f_lob INTO fil FROM lob_table WHERE key_value = 99;
dbms_lob.fileopen(fil);
-- file operations
dbms_lob.filecloseall;
EXCEPTION
WHEN some_exception
THEN handle_exception;
END;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|