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 FROM


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


Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Differences from Previous Release

A Differences from Previous ReleaseThis 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.

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Differences from Previous Release

TopicsConfiguration 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

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

Migrating From LONGs to LOBs

Using OCI Functions to Perform INSERT or UPDATE on LOBsThere 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

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

Migrating From LONGs to LOBs

Overloading with Anchored TypesFor 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

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

Migrating From LONGs to LOBs

Converting LONG to LOB Example 4: Array insertThe following example illustrates converting from LONG to LOBs when using an array INSERT: word

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

Migrating From LONGs to LOBs

Converting LONG to LOB Example 5: Simple FetchThe following example illustrates converting from LONG to LOBs when using a simple fetch: word i … , buf1 = 0; text buf2[5000]; text *selstmt = (text *) "SELECT CLIP_ID, STORY FROM MULTIMEDIA_TAB ORDER

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

Migrating From LONGs to LOBs

Retrieving an Entire Image if Less Than 32KQuestion 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.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Migrating Data from Other Directories

E Migrating Data from Other DirectoriesThis 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

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

Migrating From LONGs to LOBs

Converting LONG to LOB Example 11: CLOBs in PL/SQL Built-In FunctionsVARCHAR2(100); BEGIN -- select a CLOB column into a CLOB variable SELECT Story INTO myStory FROM

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

Migrating From LONGs to LOBs

Converting LONG to LOB Example 3: Piecewise INSERT with CallbackThe following example illustrates converting from LONG to LOBs when using a piecewise INSERT with

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

Migrating From LONGs to LOBs

Using the LONG-to-LOB API Results in an Easy MigrationExisting Tables from LONG to LOB". Application migration. This specifies how existing LONG applications

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

Migrating From LONGs to LOBs

Performancethe data from offset 1). Hence the LONG-to-LOB API improves performance of LOB INSERTs and fetches. PL

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

Migrating From LONGs to LOBs

PL/SQL IssuesQuestion 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

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

Migrating From LONGs to LOBs

Frequently Asked Questions (FAQs): LONG to LOB MigrationMoving 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.

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

Migrating From LONGs to LOBs

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

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

Migrating From LONGs to LOBs

Examples of Converting from LONG to LOB Using Table Multimedia_tab"Applications Requiring Changes When Converting From LONGs to LOBs".

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

Migrating From LONGs to LOBs

Triggers in LONGs and LOBsQuestion 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

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

Migrating From LONGs to LOBs

Using LONG-to-LOB API with OCIPrior 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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Migrating Data from Other Directories

Migrating Data from LDAP-Compliant DirectoriesThis section contains these topics: About the Data Migration Process Tasks For Migrating Data from LDAP-Compliant Directories

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

Migrating From LONGs to LOBs

Converting LONG to LOB Example 2: Piecewise INSERT with PollingContinuing 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[0], errhp, (ub4) 1, (dvoid *) &buf1, (sb4) sizeof(buf1), SQLT_INT, (dvoid *) 0, (ub2 *)0, (ub2 *)0, (ub4) 0, (ub4 *) 0, (ub4) OCI_DEFAULT);