How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
23 DBMS_LOB → The DBMS_LOB package provides subprograms to operate on BLOBs, CLOBs, NCLOBs, BFILEs, and temporary … LOBs. You can use DBMS_LOB to access and manipulation specific parts of a LOB or complete LOBs … performed under the current calling user, not under the package owner SYS. DBMS_LOB can read and modify … (LOBs) This chapter discusses
Summary of DBMS_LOB Subprograms → Table 23-4 DBMS_LOB Subprograms Subprogram Description APPEND Procedure Appends the contents of
Security for DBMS_LOB → Any DBMS_LOB subprogram called from an anonymous PL/SQL block is executed using the privileges of … the current user. Any DBMS_LOB subprogram called from a stored procedure is executed using the
LOB Locators for DBMS_LOB → All DBMS_LOB subprograms work based on LOB locators. For the successful completion of DBMS_LOB … into a local PL/SQL LOB variable and use this variable as an input parameter to DBMS_LOB for access
Rules and Limitations for DBMS_LOB → , nth must not exceed the value lobmaxsize (4GB-1) in any DBMS_LOB subprogram. For CLOB s consisting … ) for RAW and VARCHAR2 parameters used in DBMS_LOB subprograms. For example, if you declare a variable … fixed width characters. This has an important consequence for DBMS_LOB subprograms for CLOBs and NCLOBs … the ANY_CS parameter
Using DBMS_LOB to Manipulate LOBs → The DBMS_LOB package can be used to manipulate LOBs from PL/SQL. The routines that can modify BLOB … example deals with CLOB data, the second argument (834004) to DBMS_LOB. TRIM specifies the number of
Datatypes, Constants, and Exceptions for DBMS_LOB → Datatypes Parameters for the DBMS_LOB subprograms use these datatypes: Table 23-1 DBMS_LOB … the database. The DBMS_LOB package defines no special types. NCLOB is a special case of CLOBs for … specification of DBMS_LOB subprograms for CLOB s enables them to accept a CLOB or NCLOB locator variable as … input. Constants
PL/SQL (DBMS_LOB Package): Trimming LOB Data → /* Trimming LOB data */ /* Example procedure trimLOB_proc is not part of DBMS_LOB package
Calling DBMS_LOB Package From Java (JDBC) → DBMS_LOB package. This technique is used repeatedly in the examples throughout this manual.
PL/SQL (DBMS_LOB Package): Displaying LOB Data → /* Displaying LOB data.The example procedure displayLOB_proc is not part of the DBMS_LOB package
Example → TBD. LOADCLOBFROMFILE Procedure This procedure loads data from a BFILE to an internal CLOB/NCLOB with necessary character set conversion and returns the new offsets. You can specify the offsets for both the source and destination LOBs, and the number of bytes to copy from the source BFILE. The amount and src_offset, because they refer to the BFILE, are in terms of bytes, and the dest_offset is in
Pragmas → pragma restrict_references(SUBSTR, WNDS, WNPS, RNDS, RNPS);
Parameters → Table 23-51 WRITE Procedure Parameters Parameter Description lob_loc Locator for the internal LOB to be written to. amount Number of bytes (for BLOBs ) or characters (for CLOBs ) to write, or number that were written. offset Offset in bytes (for BLOBs ) or characters (for CLOBs ) from the start of the LOB (origin: 1) for the write operation. buffer Input buffer for the write.
FILECLOSE Procedure → This procedure closes a BFILE that has already been opened through the input locator. Note: Oracle has only read-only access to BFILEs. This means that BFILEs cannot be written through Oracle.
Pragmas → pragma restrict_references(ISOPEN, WNDS, RNDS, WNPS, RNPS);
Exceptions → Table 23-35 LOADFROMFILE Procedure Exceptions Exception Description VALUE_ERROR Any of the input parameters are NULL or INVALID. INVALID_ARGVAL Either: - src_offset or dest_offset LOBMAXSIZE. - amount LOBMAXSIZE.
Parameters → Table 23-36 LOADBLOBFROMFILE Procedure Parameters Parameter Description dest_lob BLOB locator of the target for the load. src_bfile BFILE locator of the source for the load. amount Number of bytes to load from the BFILE. You can also use DBMS_LOB.LOBMAXSIZE to load until the end of the BFILE. dest_offset ( IN ) Offset in bytes in the destination BLOB (origin: 1) for the start of the write. ( OUT)
Exceptions → Table 23-16 FILECLOSEALL Procedure Exception Exception Description UNOPENED_FILE No file has been opened in the session.
Syntax → DBMS_LOB.ISOPEN ( lob_loc IN BLOB) RETURN INTEGER; DBMS_LOB.ISOPEN ( lob_loc IN CLOB CHARACTER SET ANY_CS) RETURN INTEGER; DBMS_LOB.ISOPEN ( file_loc IN BFILE) RETURN INTEGER;
Parameters → Table 23-53 WRITEAPPEND Procedure Parameters Parameter Description lob_loc Locator for the internal LOB to be written to. amount Number of bytes (for BLOBs ) or characters (for CLOBs ) to write, or number that were written. buffer Input buffer for the write.