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
Exception → DBMS_TYPES.INVALID_PARAMETERS: dtype is invalid (not fully constructed, and similar deficits.)
Exception Handling → E xception Handling Oracle Streams AQ provides four integrated mechanisms to support exception … exception queues. Also, a multiconsumer exception queue cannot have subscribers associated with it … the exception queue. When a message has expired, it is moved to an exception queue. The exception
Exception Handling → Exception Han dling Each OCCI method is capable of generating an exception if it is not successful … . This exception is of type SQLException. OCCI uses the C++ Standard Template Library (STL), so any … exception that can be thrown by the STL can also be thrown by OCCI methods. The STL exceptions are … derived
19.3.2 Exception Handling → When using the HeteroRM XA feature in distributed transactions, it is recommended that the application simply check for XAException or SQLException, rather than OracleXAException or OracleSQLException. See "HeteroRM XA Messages" for a listing of HeteroRM XA messages. Note: The mapping from SQL error codes to standard XA error codes does not apply to the HeteroRM XA feature.
Exception Handling During Propagation → When system errors such as a network failure occur, Oracle Streams AQ continues to attempt to propagate messages using an exponential backoff algorithm. In some situations that indicate application errors, Oracle Streams AQ marks messages as UNDELIVERABLE if a message propagation error occurs. See Also: "Optimizing Propagation" Examples of such errors are when the remote queue does not exist or when
Exception Handling Scenario → requirements of the data warehouse. Regardless of the specific requirements, exception handling can be
C Exception Handling → C programs can raise exceptions through the OCIExtproc... functions.
Exception Handling During Propagation → E xception Handling During Propagation When a system errors such as a network failure occurs, Oracle Streams AQ continues to attempt to propagate messages using an exponential back-off algorithm. In some situations that indicate application errors Oracle Streams AQ marks messages as UNDELIVERABLE if there is an error in propagating the message. Examples of such errors are when the remote queue/topic
Oracle Streams AQ Exception Handling → Oracle Streams AQ provides four integrated mechanisms to support exception handling in applications … all expired or unserviceable messages. Applications cannot directly enqueue into exception queues … /remove them from the exception queue. To retrieve messages from exception queues, the JMS client must … use
XSU Exception Handling in Java → processing and throws an oracle.xml.sql. OracleXMLSQLException which is a runtime exception. The … calling program thus does not have to catch this exception all the time, if the program can still catch … this exception and do the appropriate action. The exception class provides functions to get the … error message
Reraising a PL/SQL Exception → Sometimes, you want to reraise an exception, that is, handle it locally, then pass it to an … error in an enclosing block. To reraise an exception, use a RAISE statement without an exception … name, which is allowed only in an exception handler: DECLARE salary_too_high EXCEPTION; current_salary
Database Scan Individual Exception Report → The scan.err file contains the Individual Exception Report. It consists of the following summaries … (30) Number of Exceptions: 0 Max Post Conversion Data Size: 30 ROWID Exception Type Size Cell Data … exception report that illustrates some possible problems when changing the database character set … Exceptions: 2 Max Post Conversion
Two Methods of Exception Generation → … A function that returns success/failure as a status value and will never raise an exception A … procedure that returns normally if it succeeds and raises an exception if it fails In each case, the
Branching to or from an Exception Handler → A GOTO statement can branch from an exception handler into an enclosing block. A GOTO statement … cannot branch into an exception handler, or from an exception handler into the current block.
9.3.1 XA Exception Classes and Methods → exceptions or SQLExceptions. An XA exception is an instance of the standard class … the Oracle SQL error code pertaining to the exception—a standard ORA error number (or 0 if there is … the exception. XA error values are defined in the javax.transaction.xa.XAException class; refer to
Continuing after an Exception Is Raised → An exception handler lets you recover from an otherwise fatal error before exiting a block. But … exception handler. In the following example, if the SELECT INTO statement raises ZERO_DIVIDE, you … INTO stats (symbol, ratio) VALUES ('XYZ', pe_ratio); EXCEPTION WHEN ZERO_DIVIDE THEN NULL; END; / You … can still handle an exception
Declaring Exceptions and Exception Handling Routines → processing of errors specific to the application. When an exception is raised (signaled), the usual … execution of the PL/SQL block stops, and a routine called an exception handler is called. Specific … exception handlers can be written to handle any internal or user-defined exception. Application code can … exception.
Oracle COM Automation for Java Exception Handling → Oracle COM Automation for Java uses standard Java exception mechanisms. Specifically, a Java … exception class, oracle.win.com.COMException, is introduced to represent COM errors. This exception is … exception is similar to that provided by the PL/SQL API GetLastError function. Note: The HRESULT data … HRESULT
Using Locator Variables to Identify Exception Locations → Using one exception handler for a sequence of statements, such as INSERT, DELETE, or UPDATE … table_name LIKE 'XYZ%'; EXCEPTION WHEN NO_DATA_FOUND THEN dbms_output.put_line('Table name not found in query ' || stmt); END; /
XSU Exception Handling in PL/SQL → these operations, particularly if these operations are performed frequently. XSU Exception Handling in … PL/SQL Here is an XSU PL/SQL exception handling example: declare queryCtx DBMS_XMLQuery.ctxType … ('select * from employees where df = dfdf'); -- set the raise exception to true … original exception to true