Two Ways to See If a BFILE is Open

Figure 11-15 Use Case Diagram: Two Ways to See If a BFILE is Open

See Also: "Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES).

Recommendation: Use OPEN to Open BFILE

As you can see by comparing the code, these alternative methods are very similar. However, while you can continue to use the older FILEISOPEN form, we strongly recommend that you switch to using ISOPEN, because this facilitates future extensibility.

1. See If the BFILE is Open with FILEISOPEN

2. See If a BFILE is Open Using ISOPEN

Specify the Maximum Number of Open BFILEs: SESSION_MAX_OPEN_FILES

A limited number of BFILEs can be open simultaneously per session. The maximum number is specified by using the SESSION_MAX_OPEN_FILES initialization parameter.

SESSION_MAX_OPEN_FILES defines an upper limit on the number of simultaneously open files in a session. The default value for this parameter is 10. That is, a maximum of 10 files can be opened simultaneously per session if the default value is utilized. The database administrator can change the value of this parameter in the init.ora file. For example:

SESSION_MAX_OPEN_FILES=20

If the number of unclosed files exceeds the SESSION_MAX_OPEN_FILES value then you will not be able to open any more files in the session. To close all open files, use the FILECLOSEALL call.