You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for DBMS_LOB


1 to 20 of 420 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 1 of 2

23 DBMS_LOBThe 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

Summary of DBMS_LOB SubprogramsTable 23-4 DBMS_LOB Subprograms   Subprogram Description APPEND Procedure Appends the contents of

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 1 of 2

Security for DBMS_LOBAny 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 1 of 2

LOB Locators for DBMS_LOBAll 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 1 of 2

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

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Working with Multimedia Datatypes

Using DBMS_LOB to Manipulate LOBsThe 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 1 of 2

Datatypes, Constants, and Exceptions for DBMS_LOBDatatypes 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

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Internal Persistent LOBs

PL/SQL (DBMS_LOB Package): Trimming LOB Data/* Trimming LOB data */ /* Example procedure trimLOB_proc is not part of DBMS_LOB package

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

LOB Support in Different Programmatic Environments

Calling DBMS_LOB Package From Java (JDBC)DBMS_LOB package. This technique is used repeatedly in the examples throughout this manual.

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Internal Persistent LOBs

PL/SQL (DBMS_LOB Package): Displaying LOB Data/* Displaying LOB data.The example procedure displayLOB_proc is not part of the DBMS_LOB package

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

ExampleTBD. 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

Pragmaspragma restrict_references(SUBSTR, WNDS, WNPS, RNDS, RNPS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

ParametersTable 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.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

FILECLOSE ProcedureThis 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.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

Pragmaspragma restrict_references(ISOPEN, WNDS, RNDS, WNPS, RNPS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

ExceptionsTable 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.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

ParametersTable 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)

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

ExceptionsTable 23-16 FILECLOSEALL Procedure Exception Exception Description UNOPENED_FILE No file has been opened in the session.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

SyntaxDBMS_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;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 2 of 2

ParametersTable 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.