The ISOPEN function checks whether a LOB is opened by using the input locator. This function is applicable to both internal and external LOBs.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this function.
Syntax
DBMS_LOB.ISOPEN (
lob_loc IN BLOB)
RETURN INTEGER;
DBMS_LOB.ISOPEN (
lob_loc IN CLOB CHARACTER SET ANY_CS)
RETURN INTEGER;
Parameters
| Parameter | Description |
|---|---|
| lob_loc | The locator of the LOB. For more information, see Use DBMS_LOB. |
Return value
1 if the LOB is opened, and 0 otherwise.
Considerations
For internal LOBs, the openness is associated with the LOB itself, not with the locator. If locator1 has opened the LOB, then locator2 also considers the LOB as opened. For internal LOBs, ISOPEN requires a round trip to the server to check the status of the LOB on the server to determine if it is indeed open.