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 EXCEPTION


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


Packages and Types Reference, 10g Release 1 (10.1)

168 ANYDATA TYPE

ExceptionDBMS_TYPES.INVALID_PARAMETERS: dtype is invalid (not fully constructed, and similar deficits.)

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

7 Oracle Streams AQ Sample Application

Exception HandlingE xception Handling Oracle Streams AQ provides four integrated mechanisms to support exceptionexception 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

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

2 Relati onal Programming

Exception HandlingException 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

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

19 JDBC OCI Extensions

19.3.2 Exception HandlingWhen 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.

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

7 Oracle Streams AQ Sample Application

Exception Handling During PropagationWhen 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

Guide, 10g Release 1 (10.1)

14 Loading and Transformation

Exception Handling Scenariorequirements of the data warehouse. Regardless of the specific requirements, exception handling can be

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

8 Calling External Procedures

C Exception HandlingC programs can raise exceptions through the OCIExtproc... functions.

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

11 Creating Oracle Streams AQ Applications Using JMS

Exception Handling During PropagationE 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

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

11 Creating Oracle Streams AQ Applications Using JMS

Oracle Streams AQ Exception HandlingOracle 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

Oracle® XML Developer's Kit Programmer's Guide, 10g Release 1 (10.1)

7 XML SQL Utility (XSU)

XSU Exception Handling in Javaprocessing 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

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Reraising a PL/SQL ExceptionSometimes, 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

Globalization Support Guide, 10g Release 1 (10.1)

12 Character Set Scanner Utilities

Database Scan Individual Exception ReportThe 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

Packages and Types Reference, 10g Release 1 (10.1)

64 DBMS_PROFILER

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

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Branching to or from an Exception HandlerA 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.

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

9 Distributed Transactions

9.3.1 XA Exception Classes and Methodsexceptions 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

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Continuing after an Exception Is RaisedAn 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

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

7 Using Procedures and Packages

Declaring Exceptions and Exception Handling Routinesprocessing 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.

Developer's Guide, 10g Release 1 (10.1)

3 Oracle COM Automation Feature Core Functionality

Oracle COM Automation for Java Exception HandlingOracle 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

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Using Locator Variables to Identify Exception LocationsUsing 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; /

Oracle® XML Developer's Kit Programmer's Guide, 10g Release 1 (10.1)

24 XSU for PL/SQL

XSU Exception Handling in PL/SQLthese 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

Platform Guide for Windows, 10g Release 1 (10.1)

15 Developing Applications for Windows

15.6.4 Exception Conditions and Error Messages15.6.3 UTL_HTTP Exception Conditions This subsection describes exceptions (errors) that can be … ; pragma restrict_references (request_pieces, wnds, rnds, wnps, rnps); 15.6.4 Exception Conditions … (such as lack of available memory), then exception UTL_HTTP.INIT_FAILED is raised: init_failed … exception; If the

User's Guide and Reference, 10g Release 1 (10.1)

G Frequently Asked Questions About PL/SQL

How Do I Continue After a PL/SQL Exception?By default, you put an exception handler at the end of a subprogram to handle exceptions that are … raised anywhere inside the subprogram. To continue executing from the spot where an exception happens … , enclose the code that might raise an exception inside another BEGIN-END block with its own … exception handler.

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

22 Monitoring Oracle Messaging Gateway

Interpreting Exception Messages in an Oracle Messaging Gateway Log FileException messages logged to the Messaging Gateway log file may include one or more linked … exceptions, identified by [Linked-exception] in the log file. These are often the most useful means of … determining the cause of a problem. For instance, a linked exception could be a java.sql.SQLException … agent being unable to establish

Globalization Support Guide, 10g Release 1 (10.1)

7 Programming with Unicode

Exception Handling for Data Loss During Datatype ConversionLOSSY_CHARSET_CONVERSION exception is raised for both implicit and explicit conversion.

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INITan exception name with an Oracle error number. That lets you refer to any internal exception by name … exception and the number is a negative value corresponding to an ORA- error number. The pragma must appear … somewhere after the exception declaration in the same declarative section, as shown in the … following

Oracle® XML Developer's Kit Programmer's Guide, 10g Release 1 (10.1)

7 XML SQL Utility (XSU)

XSU Generating XML Example 6: No Rows Exception (Java)The following code extends the previous examples to use the exception instead of checking for … { test.close(); } catch ( Exception ae ) { ae.printStackTrace(System.out); } } } } Note: Notice how … the condition to check the termination changed from checking if the result is NULL to an exception handler.

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

26 Server-Side Internal Driver

26.3 Exception-Handling Extensions for the Server-Side Internal DriverThe server-side internal driver, in addition to having standard exception-handling capabilities … () (standard method) This method returns the next exception in the chain (or if no further exceptions … ). You can start with the first exception you receive and work through the chain. int

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKC-1020 "Exception while executing the operation on the remote node {0}"Cause: Attempted to execute an operation on the remote node when the Global Services Daemon was not up on the remote node {0}. Action: Start the Global Services Daemon on the remote node using 'srvctl start'.

Error Messages, 10g Release 1 (10.1)

1 Using Messages

Oracle Exception MessagesOracle's extensive self-checking helps detect internal errors. Oracle uses the following catchall message for Oracle internal exceptions: ORA-00600: internal error code, arguments: [number], [number], [], [], [], [] An actual message might appear as follows: ORA-00600: internal error code, arguments: [1042], [3], [upilam], [], [], [] The message text can be followed by up to six arguments, which indicate

Error Messages, 10g Release 1 (10.1)

2 ORA-00000 to ORA-00830

ORA-00602: internal programming exceptioninternally, no action necessary ORA-00602: internal programming exception

Error Messages, 10g Release 1 (10.1)

32 OCI-00601 to OCI-31154

OCI-00602: internal programming exceptioninternally, no action necessary. OCI-00602: internal programming exception

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00995: unhandled exception # stringinto a PL/SQL block or subprogram. PLS-00995: unhandled exception # string

Error Messages, 10g Release 1 (10.1)

6 ORA-04930 to ORA-07499

ORA-06515: PL/SQL: unhandled exception stringparameters for stored procedures on this server or upgrade your server to a version that supports this. ORA-06515: PL/SQL: unhandled exception string

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-31628: error getting worker process exceptionDBMS_DATAPUMP.GET_STATUS to retrieve additional information. ORA-31628: error getting worker process exception

Error Messages, 10g Release 1 (10.1)

33 RMAN-00550 to RMAN-20506

RMAN-10035: exception raised in RPC: stringCause: PL/SQL detected an unhandled exception during execution of a job step, but no further … information available Action: none RMAN-10035: exception raised in RPC: string

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-13151: failed to remove exception recordCause: Operation failed to insert a record into the exception table. Action: Fix any other errors reported. ORA-13151: failed to remove exception record

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-13150: failed to insert exception recordCause: This is an internal error. Action: Contact Oracle Support Services. ORA-13150: failed to insert exception record

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKU—Command Line Parser Utility MessagesPRKU-1000: "Exception Caused by: "

Programmer's Guide, 10g Release 1 (10.1)

Bind, Define, and Describe Functions

indp IN/OUT Pointer to an indicator variable or array. For all datatypes, this is a pointer to sb2 or…alenp (IN/OUT) Pointer to array of actual lengths of array elements. Each element in alenp is the length (in bytes, unless the data in valuep is in Unicode, when it is in codepoints) of the data in the corresponding element in the bind value array before and after the execute. This parameter is ignored for dynamic binds. Note: If alenp is less than value_sz, data will be skipped.

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00485: in exception handler, ' string ' must be an exception nameerror number; then, they were referenced in different exception handlers within the same exception … different Oracle error number. PLS-00485: in exception handler, ' string ' must be an exception name

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00367: a RAISE statement with no exception name must be inside an exception handlerthe conflict. PLS-00367: a RAISE statement with no exception name must be inside an exception handler

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00483: exception ' string ' may appear in at most one exception handler in this blockthe nested subprogram as REPEATABLE PLS-00483: exception ' string ' may appear in at most one exception handler in this block

Packages and Types Reference, 10g Release 1 (10.1)

155 UTL_FILE

SyntaxUTL_FILE.FFLUSH ( file IN FILE_TYPE); invalid_maxlinesize EXCEPTION;

Packages and Types Reference, 10g Release 1 (10.1)

64 DBMS_PROFILER

Operational NotesTypical Run Two Methods of Exception Generation

Programmer's Guide, 10g Release 1 (10.1)

Cartridge Services -- OCI External Procedures

OCIExtProcRaiseExcp()Purpose Raise an Exception to PL/SQL.

Programmer's Guide, 10g Release 1 (10.1)

Cartridge Services -- OCI External Procedures

OCIExtProcRaiseExcpWithMsg()Purpose Raise an exception with a message.

Packages and Types Reference, 10g Release 1 (10.1)

101 DBMS_TRANSACTION

ExamplesDISCRETE_TRANSACTION_FAILED exception; pragma exception_init(DISCRETE_TRANSACTION_FAILED, -8175 … ); CONSISTENT_READ_FAILURE exception; pragma exception_init(CONSISTENT_READ_FAILURE, -8176);

Packages and Types Reference, 10g Release 1 (10.1)

158 UTL_INADDR

ExceptionsTable 158-1 Exception from Internet Address Package Exception Description UNKNOWN_HOST The host is unknown.

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Handling Exceptions Raised in HandlersWhen an exception occurs within an exception handler, that same handler cannot catch the exception … . An exception raised inside a handler propagates immediately to the enclosing block, which is … searched to find a handler for this new exception. From there on, the exception propagates

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

15 Oracle Streams AQ JMS Operational Interface: Shared Interfaces

AQjmsException.getLinkStringPurpose Gets the exception linked to the JMS exception. Syntax public java.lang.String … getLinkString() Usage Notes This method is used to get the exception linked to this JMS exception. In general … , this contains the SQL exception raised by the database.

Error Messages, 10g Release 1 (10.1)

7 ORA-07500 to ORA-09859

ORA-07701: sksatln: internal exception: output buffer too smallCause: An interrupt was received while archiving the logs Action: Retry operation ORA-07701: sksatln: internal exception: output buffer too small

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-24073: cannot specify RETENTION_TIME on exception queue string. string-24073: cannot specify RETENTION_TIME on exception queue string. string

Error Messages, 10g Release 1 (10.1)

6 ORA-04930 to ORA-07499

ORA-07401: sptrap: cannot restore user exception handlers.path-name of the message file shorter by reorganizing the directory hierarchy. ORA-07401: sptrap: cannot restore user exception handlers.

Error Messages, 10g Release 1 (10.1)

6 ORA-04930 to ORA-07499

ORA-06510: PL/SQL: unhandled user-defined exceptionconstraint. Note: changing the character set will impact execution of all PL/SQL code. ORA-06510: PL/SQL: unhandled user-defined exception

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-23303: application raised generic exception during deferred RPCapplication when communication is restored. ORA-23303: application raised generic exception during deferred RPC

Error Messages, 10g Release 1 (10.1)

35 LFI-00002 to LFI-01523

LFI-00003: Internal exception code. icode = [ string ], [ string ].actions necessary to make more memory available to the executing program. LFI-00003: Internal exception code. icode = [ string ], [ string ].

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00109: unknown exception name ' string ' in PRAGMA EXCEPTION_INITunits. PLS-00109: unknown exception name ' string ' in PRAGMA EXCEPTION_INIT

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-24050: subscribers are not supported for exception queue stringvalue for the agent name. Then, retry the operation. ORA-24050: subscribers are not supported for exception queue string

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-31666: Master process string had an unhandled exception.to specify the job mode. ORA-31666: Master process string had an unhandled exception.

Error Messages, 10g Release 1 (10.1)

19 ORA-38029 to ORA-39961

ORA-39065: unexpected master process exception in stringproblems. Action: Fix the problems outlined in the secondary messages. ORA-39065: unexpected master process exception in string