Results for EXCEPTION


1 to 40 of 3375 results. Prev  Next
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference

Exception Declaration

Exception DeclarationAn exception declaration declares the name of a user-defined exception. You can use the … EXCEPTION_INIT pragma to assign this name to an internally defined exception. Topics Syntax Semantics Examples … exception_declaration.eps Semantics exception_declaration exception Name of the exception that you

Database PL/SQL Language Reference

Exception Handler

Exception HandlerAn exception handler processes a raised exception. Exception handlers appear in the exception … See \" statement::= \". Semantics exception_handler exception Name of either a predefined exception … (see Table 11-3 ) or a user-defined exception (see \" Exception

Database PL/SQL Language Reference

PL/SQL Error Handling

Exception PropagationIf an exception is raised in a block that has no exception handler for it, then the exception … propagates. That is, the exception reproduces itself in successive enclosing blocks until either a block … has a handler for it or there is no enclosing block. If there is no handler for the exception, then

Database PL/SQL Language Reference

PL/SQL Optimization and Tuning

NO_DATA_NEEDED ExceptionYou must understand the predefined exception NO_DATA_NEEDED in two cases: You include an OTHERS … exception handler in a block that includes a PIPE ROW statement Your code that feeds a PIPE ROW … statement does not terminate. If the pipelined table function handles NO_DATA_NEEDED, its exception … , the pipelined table function

Database PL/SQL Language Reference

PL/SQL Error Handling

Exception CategoriesThe exception categories are: Internally defined The runtime system raises internally defined … detected while waiting for resource) and ORA-27102 (out of memory). An internally defined exception … . For more information, see \" Internally Defined Exceptions \". Predefined A predefined exception is an … internally defined exception

Database PL/SQL Language Reference

PL/SQL Error Handling

Overview of Exception Handling, and many other sources. You cannot anticipate all possible exceptions, but you can write exception … an exception-handling part, which can have one or more exception handlers. For example, an exception … -handling part could have this syntax: EXCEPTION WHEN ex_name_1 THEN statements_1 -- Exception

Database PL/SQL Language Reference

PL/SQL Triggers

Exception Handling in TriggersIn most cases, if a trigger runs a statement that raises an exception, and the exception is not … handled by an exception handler, then the database rolls back the effects of both the trigger and its … Handling, for general information about exception handling Remote Exception Handling A trigger that

Database PL/SQL Language Reference

PL/SQL Error Handling

Advantages of Exception HandlersUsing exception handlers for error-handling makes programs easier to write and understand, and … reduces the likelihood of unhandled exceptions. Without exception handlers, you must check for every … scattered throughout the program. With exception handlers, you need not know every possible error or … everywhere that it might

Database PL/SQL Language Reference

PL/SQL Error Handling

Propagation of Exceptions Raised in Exception HandlersAn exception raised in an exception handler propagates immediately to the enclosing block (or to … the invoker or host environment if there is no enclosing block). Therefore, the exception handler must … the predefined exception ZERO_DIVIDE, and control transfers to the ZERO_DIVIDE exception handler

Database Development Guide

Advanced PL/SQL Features

Exception Handling, and many other sources. You cannot anticipate all possible exceptions, but you can write exception

Database Development Guide

SQL Processing for Application Developers

Exception ExplanationDBMS_APP_CONT.GET_LTXID_OUTCOME procedure raises one of these exceptions: Exception Explanation ORA-14950

Database PL/SQL Language Reference

PL/SQL Optimization and Tuning

To handle exceptions raised in a FORALL statement immediately, omit the SAVE EXCEPTIONS clause and write…unhandled exception, then PL/SQL stops the FORALL statement and rolls back all changes made by previous DML … order, unless one of them raises an unhandled exception: DELETE FROM employees_temp WHERE … employees_temp WHERE department_id = depts(70); If the third statement raises an unhandled exception, then PL … an unhandled exception,

Application Express SQL Workshop Guide

Using Oracle Application Express Utilities

5.4.3 Viewing Exception ReportsUse the Exception Reports to view unindexed foreign keys and tables without primary keys, indexes … , or triggers. To view Exception reports: On the Workspace home page, click the SQL Workshop. Click … Utilities. Click Object Reports. The Object Reports page appears. In the Exception Reports section

Database PL/SQL Language Reference

PL/SQL Error Handling

RAISE StatementThe RAISE statement explicitly raises an exception. Outside an exception handler, you must specify … the exception name. Inside an exception handler, if you omit the exception name, the RAISE statement … reraises the current exception. Topics Raising User-Defined Exception

Database 2 Day + Java Developer's Guide

Exception Handling

Exception Handlingerror, which is used as the Java Exception message, available via the getMessage method. The sample … , if a method throws an exception, there needs to be a mechanism to handle it. Generally, a catch … block catches the exception and specifies the course of action in the event of an exception, which … exception.

Database PL/SQL Language Reference

RAISE Statement

RAISE StatementThe RAISE statement explicitly raises an exception. Outside an exception handler, you must specify … the exception name. Inside an exception handler, if you omit the exception name, the RAISE statement … reraises the current exception. Topics Syntax Semantics Examples Related Topics

Database PL/SQL Language Reference

PL/SQL Error Handling

User-defined User Only if you assign one Always No AlwaysFor details, see \" Raising Internally Defined Exception with RAISE Statement \". For a named … exception, you can write a specific exception handler, instead of handling it with an OTHERS exception … handler. A specific exception handler is more efficient than an OTHERS exception handler,

Database PL/SQL Language Reference

PL/SQL Error Handling

Internally Defined ExceptionsReference. The runtime system raises them implicitly (automatically). An internally defined exception … that do not have names, then give them names so that you can write exception handlers specifically … for them. Otherwise, you can handle them only with OTHERS exception handlers. To give a name to an … internally defined exception,

Database PL/SQL Language Reference

PL/SQL Error Handling

Redeclared Predefined Exceptionsexception name that is a predefined exception name. (For a list of predefined exception names, see Table … 11-3.) If you redeclare a predefined exception, your local declaration overrides the global … declaration in package STANDARD. Exception handlers written for the globally declared exception

Database PL/SQL Language Reference

PL/SQL Error Handling

User-Defined Exceptions, subprogram, or package. An exception name declaration has this syntax: exception_name EXCEPTION; For … semantic information, see \" Exception Declaration \". You must raise a user-defined exception explicitly

Database PL/SQL Language Reference

PL/SQL Error Handling

Propagation of Exceptions Raised in DeclarationsAn exception raised in a declaration propagates immediately to the enclosing block (or to the … invoker or host environment if there is no enclosing block). Therefore, the exception handler must be in … VALUE_ERROR exception handler is in the same block as the declaration that raises VALUE_ERROR. Because … the exception

Database PL/SQL Language Reference

PL/SQL Error Handling

This table gives the names and error numbers of the PL/SQL predefined exceptions.Raising User-Defined Exception with RAISE Statement In Example 11-10, the procedure declares an … exception named past_due, raises it explicitly with the RAISE statement, and handles it with an … exception handler. Example 11-10 Declaring, Raising, and Handling User-Defined Exception CREATE PROCEDURE … account_status

Database PL/SQL Language Reference

PL/SQL Error Handling

RAISE_APPLICATION_ERROR ProcedureReraising Current Exception with RAISE Statement In an exception handler, you can use the RAISE … statement to\"reraise\" the exception being handled. Reraising the exception passes it to the enclosing … block, which can handle it further. (If the enclosing block cannot handle the reraised exception

Database PL/SQL Language Reference

PL/SQL Error Handling

Raising Exceptions ExplicitlyTo raise an exception explicitly, use either the RAISE statement or RAISE_APPLICATION_ERROR

Database PL/SQL Language Reference

EXCEPTION_INIT Pragma

EXCEPTION_INIT PragmaThe EXCEPTION_INIT pragma associates a user-defined exception name with an error code. The … EXCEPTION_INIT pragma can appear only in the same declarative part as its associated exception, anywhere … after the exception declaration. Topics Syntax Semantics Examples Related Topics Syntax … exception Name of a previously

Database PL/SQL Language Reference

List of Figures

List of FiguresTransaction Control Flow 8-1 How PL/SQL Compiler Resolves Invocations 11-1 Exception Does Not Propagate … 11-2 Exception Propagates from Inner Block to Outer Block 11-3 PL/SQL Returns Unhandled Exception Error to Host Environment

Streams Concepts and Administration

Glossary

exception queueMessages are transferred to an exception queue if they cannot be retrieved and processed for some reason.

Database PL/SQL Language Reference

Overview of PL/SQL

Error HandlingPL/SQL makes it easy to detect and handle errors. When an error occurs, PL/SQL raises an exception … . Normal execution stops and control transfers to the exception-handling part of the PL/SQL block

Database PL/SQL Language Reference

PL/SQL Error Handling

Unhandled ExceptionsIf there is no handler for a raised exception, PL/SQL returns an unhandled exception error to the … unhandled exception, PL/SQL does not roll back database changes made by the subprogram. The FORALL … one set of values raises an unhandled exception, then PL/SQL rolls back all database changes made … exceptions

Spatial and Graph Developer's Guide

SDO_GEOM Package (Geometry)

tolTolerance value (see Tolerance ). Usage Notes An exception is raised if geom1 and geom2 are based

Spatial and Graph Developer's Guide

SDO_GEOM Package (Geometry)

tolTolerance value (see Tolerance ). Usage Notes An exception is raised if geom1 and geom2 are based

Spatial and Graph Developer's Guide

SDO_GEOM Package (Geometry)

tolTolerance value (see Tolerance ). Usage Notes An exception is raised if geom1 and geom2 are based

Spatial and Graph Developer's Guide

SDO_LRS Package (Linear Referencing System)

dim_arraythe start measure of geom_segment. An exception is raised if geom_segment has an invalid geometry type

Spatial and Graph Developer's Guide

SDO_LRS Package (Linear Referencing System)

dim_arraythe end measure of geom_segment. An exception is raised if geom_segment has an invalid geometry type

Database PL/SQL Language Reference

SQLCODE Function

SQLCODE FunctionIn an exception handler, the SQLCODE function returns the numeric code of the exception being … handled. (Outside an exception handler, SQLCODE returns 0.) For an internally defined exception, the … the error \"no data found\", whose numeric code is +100. For a user-defined exception, the numeric

Database PL/SQL Language Reference

PL/SQL Error Handling

Retrying Transactions After Handling ExceptionsTo retry a transaction after handling an exception that it raised, use this technique: Enclose the … transaction in a sub-block that has an exception-handling part. In the sub-block, before the … transaction starts, mark a savepoint. In the exception-handling part of the sub-block, put an exception … transaction

Database PL/SQL Language Reference

PL/SQL Error Handling

Continuing Execution After Handling ExceptionsAfter an exception handler runs, control transfers to the next statement of the enclosing block (or … to the invoker or host environment if there is no enclosing block). The exception handler cannot … raises ZERO_DIVIDE and the exception handler handles it, execution cannot continue from the INSERT … with its own ZERO_DIVIDE exception

Database PL/SQL Language Reference

PL/SQL Language Fundamentals

Error-Reporting FunctionsPL/SQL has two error-reporting functions, SQLCODE and SQLERRM, for use in PL/SQL exception-handling





Was this page helpful?

Integrated Cloud Applications & Platform Services