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
A Differences from Previous Release → This appendix lists differences between Pro*PL/I precompiler release 1.5 and 1.6. Each feature modification is followed by one or more page numbers referencing the relevant section in this Manual. Bold page numbers refer to the section with the main description of the feature.
Topics → Configuration files 3-3, 3-4 DBMS Option 1-13, 1-15, 3-5 INLINE option 3-2 MODE Option 1-13, 3-7 sqlglm() 2-15 SQLSTATE variable 1-7, 2-2 Copyright © 1996-2001 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback
Using OCI Functions to Perform INSERT or UPDATE on LOBs → There are various ways to perform INSERT or UPDATE of LOB data. Note: These are in addition to the ways to insert LOB locators, which are documented in Chapter 10, "Internal Persistent LOBs". In all the ways described in the following, it is assumed that you have initialized the OCI environment and allocated all necessary handles. Simple INSERTs or UPDATEs in One Piece To perform simple INSERTs and
Overloading with Anchored Types → For applications using anchored types, some overloadings would silently resolve to different targets during the conversion to LOBs. For example: procedure p(l long) is...; -- (1) procedure p(c clob) is...; -- (2) Consider the caller: declare var longtab.longcol%type; begin... p(var);... end; Prior to LOB migration this call would have resolved to overload (1). Once longtab is migrated to LOBs this
Converting LONG to LOB Example 4: Array insert → The following example illustrates converting from LONG to LOBs when using an array INSERT: word
Converting LONG to LOB Example 5: Simple Fetch → The following example illustrates converting from LONG to LOBs when using a simple fetch: word i … , buf1 = 0; text buf2; text *selstmt = (text *) "SELECT CLIP_ID, STORY FROM MULTIMEDIA_TAB ORDER
Retrieving an Entire Image if Less Than 32K → Question I can now SELECT LOB data without first retrieving the locator. Can I now retrieve an entire image with a single SELECT in PL/SQL if the image is less than 32K? Answer Yes.
E Migrating Data from Other Directories → This appendix tells how to migrate data from both LDAP Version 3-compatible directories and … : Migrating Data from LDAP-Compliant Directories Migrating User Data from Application-Specific Repositories
Converting LONG to LOB Example 11: CLOBs in PL/SQL Built-In Functions → VARCHAR2(100); BEGIN -- select a CLOB column into a CLOB variable SELECT Story INTO myStory FROM
Converting LONG to LOB Example 3: Piecewise INSERT with Callback → The following example illustrates converting from LONG to LOBs when using a piecewise INSERT with
Using the LONG-to-LOB API Results in an Easy Migration → Existing Tables from LONG to LOB". Application migration. This specifies how existing LONG applications
Performance → the data from offset 1). Hence the LONG-to-LOB API improves performance of LOB INSERTs and fetches. PL
PL/SQL Issues → Question Does a fetch of a LOB column (with size > 32K) into a PL/SQL CHAR/RAW/LONG/LONG RAW buffer raise an exception? Answer In OCIDefineByPos() and PL/SQL "SELECT INTO" commands, there is no way of specifying the "amount" wanted. You only specify the buffer length. The correct amount is fetched without overflowing the buffer, no matter what the LOB size is. If the whole column is not fetched, then
Frequently Asked Questions (FAQs): LONG to LOB Migration → Moving From LOBs Back to LONGs Question Once we ALTER a table to change LONG columns to LOB and … read the data from the LOB column and insert it into the LONG column. Then you can drop the LOB column.
Are OCI LOB Routines Obsolete? → Question How does OCIStmtFetch() work for LOB columns? Does it return OCI_NEED_DATA as it previously did for LONG column and must data be completely fetched before the data for other columns is available? Are all OCI routines for LOBs obsolete, such as, OCILobRead(), OCILobWrite(),...? Answer OCIStmtFetch() for LOBs works the same way as it did for LONGs previously if the datatype is specified as
Examples of Converting from LONG to LOB Using Table Multimedia_tab → "Applications Requiring Changes When Converting From LONGs to LOBs".
Triggers in LONGs and LOBs → Question In Triggers, some functionality is supported for LONGs that is not supported for LOBs. Will this cause a problem? Answer There are a couple of limitations on how LOBs work with triggers. See "LONG-to-LOB Migration Limitations". Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback
Using LONG-to-LOB API with OCI → Prior to this release, OCI provided interface calls for performing piecewise INSERTS, UPDATES, and fetches of LONG data. These APIs also allow you to provide data dynamically in case of array INSERTs or UPDATEs, instead of providing a static array of bind values. These piecewise operations can be performed by polling or by providing a callback. The following functions are now supported for LOBs for
Migrating Data from LDAP-Compliant Directories → This section contains these topics: About the Data Migration Process Tasks For Migrating Data from LDAP-Compliant Directories
Converting LONG to LOB Example 2: Piecewise INSERT with Polling → Continuing the preceding example... text *sqlstmt = (text *)"INSERT INTO MULTIMEDIA_TAB VALUES (:1,:2)"; ub2 rcode; ub1 piece, i; OCIStmtPrepare(stmthp, errhp, sqlstmt, (ub4)strlen((char *)sqlstmt), (ub4) OCI_NTV_SYNTAX, (ub4) OCI_DEFAULT); OCIBindByPos(stmthp, &bndhp, errhp, (ub4) 1, (dvoid *) &buf1, (sb4) sizeof(buf1), SQLT_INT, (dvoid *) 0, (ub2 *)0, (ub2 *)0, (ub4) 0, (ub4 *) 0, (ub4) OCI_DEFAULT);