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


21 to 80 of 1676 results. previous page Prev  Next next page
Results per page:  20 | 40 |  60 


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

LOB Functions

svchp (IN)is called for an internal LOB. No error is returned if the BFILE exists but is not opened. This

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

LOB Functions

svchp (IN/OUT)the LOB. flag (IN) When set to OCI_LOB_BUFFER_FREE, the buffer resources for the LOB are freed after … subsystem that are associated with the LOB referenced by the input locator. This routine will actually … write the data in the buffer to the LOB in the database. LOB buffering must have already been

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

LOB Functions

For BFILEsassociated with the LOB, not with the locator. If locator1 opened the LOB then locator2 also sees the LOB … server to see if the LOB is indeed open. For external LOBs ( BFILEs ), this call also requires a

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

LOB Functions

OCILobLoadFromFile2()Purpose Load and copy all or a portion of the file into an internal LOB. This function must be used

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

LOB Functions

offset (IN)On input, this is the absolute offset from the beginning of the LOB value. For character LOBs … ( CLOBs, NCLOBs ) it is the number of characters from the beginning of the LOB, for binary LOBs or BFILE … OCI_CONTINUE for the read to continue. If any other error code is returned, the LOB read is terminated … consistent with the

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

LOB Functions

OCILobRead2()Purpose Reads a portion of a LOB or BFILE, as specified by the call, into a buffer. This function

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

LOB Functions

OCILobTrim2()Purpose Truncates the LOB value to a shorter length. This function must be used for LOBs of size

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

LOB Functions

duration (OUT)… See Also: \"Temporary LOB Durations\" Related Functions OCIDurationEnd()

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. dst_locp (IN/OUT) An internal LOB locator uniquely … referencing the destination LOB. This locator must be a locator that was obtained from the server … specified by svchp. src_locp (IN) An internal LOB locator uniquely referencing the source LOB. This locator

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

LOB Functions

envhp (IN/OUT)information in the event of an error. locp (IN) LOB locator for which to get the character set ID … . csid (OUT) Database character set ID of the input LOB locator. If the input locator is for a BLOB or

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

LOB Functions

OCILobGetChunkSize()Purpose Gets the chunk size of a LOB. Syntax sword OCILobGetChunkSize ( OCISvcCtx *svchp, OCIError

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. locp (IN) Pointer to the LOB locator being … examined. The locator can refer to an internal or external LOB. flag (OUT) Returns TRUE if the internal LOB … Checks to see if the internal LOB is open or if the BFILE was already opened using the input locator.

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

OCILobRead()Purpose Reads a portion of a LOB or BFILE, as specified by the call, into a buffer. Syntax sword

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

LOB Functions

OCILobWriteAppend2()Purpose Writes data starting at the end of a LOB. This function must be used for LOBs of size

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

LOB Functions

env (IN/OUT)… Temporary LOBs that are allocated for the user duration are freed. See Also: \"Temporary LOB Durations\" Related Functions OCIDurationBegin()

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

LOB Functions

svchp (IN/OUT)size of the LOB locator array. For polling this is relevant only for the first call and is ignored in … written to. locp_arr (IN/OUT) An array of LOB locators. byte_amt _arr (IN/OUT) An array of pointers to … in the array is the absolute offset from the beginning of the LOB value. For character LOBs ( CLOB s … , NCLOB s) it is

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

LOB Functions

envhp (IN/OUT)information in the event of an error. locp (IN) LOB locator for which to get the character set form … . csfrm (OUT) Character set form of the input LOB locator. If the input locator, locp, is for a BLOB

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. dst_locp (IN/OUT) An internal LOB locator uniquely … referencing the destination LOB. This locator must be a locator that was obtained from the server … specified by svchp. src_locp (IN) An internal LOB locator uniquely referencing the source LOB. This locator

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

LOB Functions

OCILobFileExists()Purpose Tests to see if the BFILE exists on the server's operating system. Syntax sword OCILobFileExists ( OCISvcCtx *svchp, OCIError *errhp, OCILobLocator *filep, boolean *flag ); Parameters

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

LOB Functions

svchp (IN)function for an internal LOB. See Also: For more information about BFILE s, refer to the description of

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

LOB Functions

envhp (IN/OUT)this function for an internal LOB. See Also: For more information about BFILE s, refer to the

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

LOB Functions

svchp (IN)for an internal LOB. This function is only meaningful the first time it is called for a particular

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

LOB Functions

OCILobFlushBuffer()Purpose Flush/write all buffers for this lob to the server. Syntax sword OCILobFlushBuffer

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. locp (IN/OUT) The internal LOB for which to get the … space that is used to store the internal LOB value. This is the amount that users should use when … reading or writing the LOB value. If possible, users should start their writes at chunk boundaries … an internal LOB,

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

LOB Functions

OCILobGetStorageLimit()Purpose Gets the maximum length of an internal LOB ( BLOB, CLOB, or NCLOB ) in bytes. Syntax sword

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. locp (IN) A LOB locator that uniquely references the … LOB. The locator must be one that was obtained from the server specified by svchp. limitp (OUT) The … maximum length of the LOB (in bytes) that can be stored in the database. Comments Because block size … ranges from 2KB to

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

LOB Functions

envhp (IN)The OCI environment handle. x (IN) LOB locator to compare. y (IN) LOB locator to compare. is_equal … (OUT) TRUE, if the LOB locators are equal; FALSE if they are not. Comments Compares the given LOB or … BFILE locators for equality. Two LOB or BFILE locators are equal if and only if they both refer to

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

LOB Functions

svchp (IN)destination internal LOB which may be of type BLOB, CLOB, or NCLOB. src_locp (IN/OUT) A locator uniquely … the absolute offset for the destination LOB. For character LOBs it is the number of characters from … the beginning of the LOB at which to begin writing. For binary LOBs it is the number of bytes from … the beginning of the

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. locp (IN/OUT) The LOB to open. The locator can refer to … an internal or external LOB. mode (IN) The mode in which to open the LOB or BFILE. In Oracle8 i or … locator is for a BFILE. Comments It is an error to open the same LOB twice. BFILEs cannot be opened in

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 … LOB value. For character LOBs ( CLOBs, NCLOBs ) it is the number of characters from the beginning of … the LOB,

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) The LOB locator that uniquely references … the LOB. This locator must be a locator that was obtained from the server specified by svchp … (\"|\"). An error results if you specify an option_types value that is not enabled on the LOB column

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) An internal LOB locator that uniquely … references the LOB. This locator must be a locator that was obtained from the server specified by svchp … : Table 17-5 Characters or Bytes in amtp LOB or BFILE Input with fixed-width client-side character … data that the user

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

LOB Functions

OCILobWriteAppend()Purpose Writes data starting at the end of a LOB. Syntax sword OCILobWriteAppend ( OCISvcCtx *svchp

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

LOB Functions

OCIDurationBegin()Purpose Starts a user duration for a temporary LOB. Syntax sword OCIDurationBegin ( OCIEnv *env

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

LOB Functions

OCILobClose()Purpose Closes a previously opened LOB or BFILE. Syntax sword OCILobClose ( OCISvcCtx *svchp, OCIError *errhp, OCILobLocator *locp ); Parameters

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

LOB Functions

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

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

LOB Functions

OCILobFileOpen()Purpose Opens a BFILE on the file system of the server for read-only access. Syntax sword OCILobFileOpen ( OCISvcCtx *svchp, OCIError *errhp, OCILobLocator *filep, ub1 mode ); Parameters

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

LOB Functions

envhp (IN/OUT)function for an internal LOB. See Also: For more information about BFILE s, refer to the

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

LOB Functions

OCILobLoadFromFile()Purpose Load and copy all or a portion of the file into an internal LOB. Syntax sword

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

LOB Functions

svchp (IN/OUT)diagnostic information in the event of an error. src_locp (IN) The LOB/ BFILE locator to copy from … . dst_locpp (IN/OUT) The LOB/ BFILE locator to copy to. The caller must allocate space for the … destination locator. After the assignment, both locators refer to the same LOB data. For internal LOBs, the … source locator's LOB

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

LOB Functions

envhp (IN/OUT)information in the event of an error. locp (IN) The LOB or BFILE locator being tested … is_initialized (OUT) Returns TRUE if the given LOB or BFILE locator is initialized; FALSE if it is not. Comments … Tests to see if a given LOB or BFILE locator is initialized. Internal LOB locators can be … initialized by one

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

OCILobSetOptions()Purpose Enables option settings for a SecureFile LOB. Syntax sword OCILobSetOptions ( OCISvcCtx

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

LOB Functions

OCILobTrim()Purpose Truncates the LOB value to a shorter length. Syntax sword OCILobTrim ( OCISvcCtx *svchp

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. locp (IN/OUT) An internal LOB locator that uniquely … references a LOB. amtp (IN/OUT) The value in amtp is the amount in either bytes or characters, as shown … in this table: Table 17-6 Characters or Bytes in amtp LOB or BFILE Input with fixed-width client-side … of bytes of data

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

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

LOB Functions

OCIDurationEnd()Purpose Terminates a user duration for a temporary LOB. Syntax sword OCIDurationEnd ( OCIEnv *env

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

LOB Functions

OCILobAppend()Purpose Appends a LOB value at the end of another LOB as specified. Syntax sword OCILobAppend

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

LOB Functions

svchp (IN/OUT)size of the LOB locator array. For polling this is relevant only for the first call and is ignored in … . locp_arr (IN) An array of LOB or BFILE locators. byte_amt_arr (IN/OUT) An array of oraub8 variables … beginning of the LOB; for binary LOBs or BFILE s it is the number of bytes. The first position is 1 … other error code is

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

LOB Functions

OCILobAssign()Purpose Assigns one LOB or BFILE locator to another. Syntax sword OCILobAssign ( OCIEnv *envhp

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

LOB Functions

OCILobCharSetForm()Purpose Gets the character set form of the LOB locator, if any. Syntax sword OCILobCharSetForm

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

LOB Functions

OCILobCopy()Purpose Copies all or a portion of a LOB value into another LOB value. Syntax sword OCILobCopy

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

LOB Functions

OCILobCopy2()Purpose Copies all or a portion of a LOB value into another LOB value. This function must be used

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

LOB Functions

svchp (IN)diagnostic information in the event of an error. locp (IN/OUT) An internal LOB locator that uniquely … references the LOB. This locator must be a locator that was obtained from the server specified by svchp … NCLOB s, or bytes for BLOB s, from the beginning of the LOB value from which to start erasing data … , erasing means that

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

LOB Functions

OCILobFileClose()Purpose Closes a previously opened BFILE. Syntax sword OCILobFileClose ( OCISvcCtx *svchp, OCIError *errhp, OCILobLocator *filep ); Parameters

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

LOB Functions

OCILobFileGetName()Purpose Gets the BFILE locator's directory object and file name. Syntax sword OCILobFileGetName ( OCIEnv *envhp, OCIError *errhp, const OCILobLocator *filep, OraText *dir_alias, ub2 *d_length, OraText *filename, ub2 *f_length ); Parameters

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

LOB Functions

OCILobFileIsOpen()Purpose Tests to see if the BFILE is open Syntax sword OCILobFileIsOpen ( OCISvcCtx *svchp, OCIError *errhp, OCILobLocator *filep, boolean *flag ); Parameters

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

LOB Functions

OCILobFileSetName()Purpose Sets the directory object and file name in the BFILE locator. Syntax sword OCILobFileSetName ( OCIEnv *envhp, OCIError *errhp, OCILobLocator **filepp, const OraText *dir_alias, ub2 d_length, const OraText *filename, ub2 f_length ); Parameters

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

LOB Functions

OCILobFreeTemporary()Purpose Free a temporary LOB Syntax sword OCILobFreeTemporary( OCISvcCtx *svchp, OCIError *errhp, OCILobLocator *locp); Parameters