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
Contents → Structure Related Documents Conventions 1 Introduction to the OLAP API 1.1 OLAP API Overview 1.1.1 … Development 1.2 Sample Schema for OLAP API Examples 1.3 Access to Data and Metadata Through the OLAP API … 1.3.1 MDM Model in the OLAP API 1.3.2 Access to Data Through the OLAP API 1.3.3 Unique and Local … : Connect to
Contents → Connecting to Oracle 2 Error Handling and Diagnostics Error Handling Alternatives Using Status
Contents → Variables 1.7 CHARACTER VARYING 1.7.1 VARYINGReturning Nulls to a CHARACTER (N) 1.8 Handling … Truncated Values 1.12.3 SQLCHECK 1.13 Connecting to Oracle 1.13.1 Automatic Logins 1.13.2 Concurrent
VARCHAR Variables → can use the VARCHAR pseudotype to declare variable-length character strings. (A pseudotype is a … datatype not native to your host language.) Recall that VARCHAR variables have a 2-byte length field
Indicator Variables → spaces, a single double-byte space is left in the buffer to act as a sentinel. Output host variables … trailing double-byte spaces. The length component is assumed to be the length of the data in characters … to the length of the data in characters, not bytes. STRING / LONG VARCHAR. These host variables are
Using Method 3 → CONNECT:username IDENTIFIED BY:password; display 'Connected to Oracle'; set sql_stmt = 'INSERT INTO EMP … WORK RELEASE; exit program with an error; Using Method 3 Method 3 is similar to Method 2 but combines … the PREPARE statement with the statements needed to define and manipulate a cursor. This allows your … program to
Using the SAVEPOINT Statement → it to make sure it follows syntax rules and refers to valid database objects. Errors detected while … . Oracle can also roll back single SQL statements to break deadlocks. Oracle signals an error to one … the SAVEPOINT Statement You use the SAVEPOINT statement to mark and name the current point in the
Eliminating Unnecessary Parsing → application relies on table-level locking, modify it to take advantage of row-level locking. In general
LRECLEN → Notes Cannot be entered inline. By default, the listing file is written to the current directory
UNSAFE_NULL → Purpose Specifying UNSAFE_NULL=YES prevents generation of ORA-01405 messages when fetching NULLs without using indicator variables.
Compiling and Linking → local SQL statements. Compiling and Linking To get an executable program, you must compile the source … from SQLLIB and system-specific Oracle libraries. Also, if you are embedding OCI calls, make sure to … modules. If these references conflict, the link fails. This can happen when you try to link third party … might have problems.
Opening a Cursor → precompilation unit to another. Also, cursor names cannot be hyphenated. They can be any length, but only … referencing the cursor. That is, forward references to the cursor are not allowed. In the following … many cursors, you might want to specify the MAXOPENCURSORS option. For more information about … MAXOPENCURSORS, see page
A Complete Example → returns the "no data found" Oracle warning code to SQLCODE in the SQLCA. The cumulative number of rows … EXEC SQL WHENEVER SQLERROR DO sql_error; -- log on to Oracle EXEC SQL CONNECT:username IDENTIFIED BY … :password; display 'Connected to Oracle'; -- declare a cursor EXEC SQL DECLARE emp_cursor CURSOR
Steps in Developing an Embedded SQL Application → statement, the Oracle Server returns a status code to a variable named SQLCODE or SQLSTATE. The status … Oracle to pass runtime status information to the program. With the SQLCA, you can take different … actions based on feedback from Oracle about work just attempted. For example, you can check to see if … can
MODE → Syntax MAXOPENCURSORS= integer Default 10 Usage Notes You can use MAXOPENCURSORS to improve the … tries to reuse an entry. Its success depends on the values of HOLD_CURSOR and RELEASE_CURSOR, and, for … it cannot find one to reuse. If necessary, Oracle keeps allocating additional cache entries until … it runs out of memory or
DECLARE STATEMENT (Embedded SQL Directive) → Purpose To declare an identifier for a SQL statement or PL/SQL block to be used in other embedded SQL statements.
Restrictions → statement are limited to one dimension. So, the two-dimensional array declared in the following example is invalid:
Namespace Library → O OCI functions S function names from SQLLIB and system-dependent libraries XA external functions for XA applications only GEN KP L NA NC ND NL NM NR NS NT NZ TTC UPI Internal functions Table B - 1. Oracle Reserved Namespaces
3. On input, host string must be in hex format. On output, column value is returned in same format.… → Table 3 - 6. Supported Datatype Conversions
OPEN → EXEC SQL DECLARE emp_cursor CURSOR FOR sql_stmt; The identifiers sql_stmt and emp_cursor are not host or program variables, but must be unique. If you declare two cursors using the same statement name, the precompiler considers the two cursor names synonymous. For example, if you execute the statements EXEC SQL PREPARE sql_stmt FROM:select_stmt; EXEC SQL DECLARE emp_cursor FOR sql_stmt; EXEC SQL PREPARE