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 LOB


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


Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

Predefined PL/SQL Large Object (LOB) Data TypesLarge object (LOB) data types reference large objects that are stored separately from other data … items, such as text, graphic images, video clips, and sound waveforms. LOB data types allow efficient … , random, piecewise access to this data. Predefined PL/SQL LOB data types are listed and described in … Table 3-9. Table 3-9

Database Concepts, 11g Release 1 (11.1)

Oracle Data Types

LOB Character Datatypes… Implicit conversion between CHAR/VARCHAR2 and NCHAR/NVARCHAR2 is also supported. LOB Character Datatypes

Database Concepts, 11g Release 1 (11.1)

Oracle Data Types

Overview of LOB DatatypesThe LOB datatypes BLOB, CLOB, NCLOB, and BFILE enable you to store and manipulate large blocks of … you always use LOB datatypes over LONG datatypes. You can perform parallel queries (but not parallel … DML or DDL) on LOB columns. LOB datatypes differ from LONG and LONG RAW datatypes in several ways … . For example:

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Concepts

Supported LOB TypesA LOB is a large object type. This release of SQL*Loader supports loading of four LOB types: BLOB … : a LOB containing unstructured binary data CLOB: a LOB containing character data NCLOB: a LOB … control file data definition language to load these LOB types

Database Utilities, 11g Release 1 (11.1)

Loading Objects, LOBs, and Collections

Loading LOB Data from LOBFILEsLOB data can be lengthy enough so that it makes sense to load it from a LOBFILE instead of from a … primary datafile. In LOBFILEs, LOB data instances are still considered to be in fields (predetermined … avoided. This type of organization of data is ideal for LOB loading. There is no requirement that a … LOB from

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

Large Objects (LOBs)

LOB LocatorsA LOB locator points to the actual LOB contents. The locator is returned when you retrieve the LOB … , not the LOB's contents. LOB locators cannot be saved in one transaction or session and used again in a later transaction or session.

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

LOBs

LOB LocatorsA LOB locator points to the actual LOB contents. The locator is returned when you retrieve the LOB … , not the LOB's contents. LOB locators cannot be saved in one transaction or session and used again in a later transaction or session.

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

LOBs

LOB StatementsThe statements are presented alphabetically. In all the statements where it appears, database refers to a database connection

Objects for OLE Developer's Guide, 11g Release 1 (11.1)

Tuning and Troubleshooting

LOB ErrorsTable 5-6 lists the LOB errors. Table 5-6 LOB Errors Constant Value Description … OERROR_INVSEEKPARAMS 4897 Invalid seek value is specified for the LOB read/write operation. OERROR_LOBREAD 4898 Read … operation is not byte. OERROR_INVLOBLEN 4902 Invalid buffer length for the LOB write operation … Invalid input

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

LOB Support

LOB SupportODP.NET provides an easy and optimal way to access and manipulate large object (LOB) data types … Provider for.NET LOB Objects Updating LOBs Using a DataSet Updating LOBs Using OracleCommand and … OracleParameter Updating LOBs Using ODP.NET LOB Objects Temporary LOBs

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

Large Objects (LOBs)

LOB StatementsThe statements are presented alphabetically. In all the statements where it appears, database refers to a database connection

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

LOB FunctionsThis section describes the LOB functions which use the LOB locator. Use functions that end in \"2 … described in these sections: See Also: \"Binding LOB Data\" for usage and examples for both INSERT … and UPDATE statements \"Defining LOB Data\" for usage and examples of SELECT statements Chapter 7 … , \"LOB

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

Datatypes

LOB DescriptorA LOB (Large Object) stores binary or character data up to 128 terabytes in length. Binary data is … stored in a BLOB (Binary LOB), and character data is stored in a CLOB (Character LOB) or NCLOB … (National Character LOB). LOB values may or may not be stored inline with other row data in the database

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

New Features

LOB Supportthe LOB interface. See the chapter Chapter 16, \"LOBs\" for complete details.

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

OCILobErase()Purpose Erases a specified portion of the internal LOB data starting at a specified offset. Syntax

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

svchp (IN/OUT)diagnostic information in the event of an error. locp (IN/OUT) A locator uniquely referencing the LOB … to be freed. Comments This function frees the contents of the temporary LOB to which this locator … returns an error if the LOB locator passed in the locp parameter does not point to a temporary LOB … , which

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

envhp (IN)TRUE if the LOB locator points to a temporary LOB; FALSE if it does not. Comments This function … tests a locator to determine if it points to a temporary LOB. If so, is_temporary is set to TRUE. If

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

svchp (IN/OUT)diagnostic information in the event of an error. locp (IN) A LOB or BFILE locator that uniquely references … the LOB or BFILE. This locator must be a locator that was obtained from the server specified by … table: Table 17-4 Characters or Bytes in amtp LOB or BFILE Input Output with fixed-width client-side … polling. If the amount

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

OCILobWrite2()Purpose Writes a buffer into a LOB. This function must be used for LOBs of size greater than 4 GB

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

bufp (IN)contain the first piece of the LOB when this call is invoked. If a callback is provided, bufp must … return OCI_CONTINUE for the write to continue. If any other error code is returned, the LOB write is … SQLCS_IMPLICIT. Comments The buffer can be written to the LOB in a single piece with this call, or it can be … OCILobWriteAppend()