Results for EXCEPTION


1 to 14 of 14 results.


Database Administrator's Guide, 11g Release 1 (11.1)

Handling Errors in Remote Procedures

Handling Errors in Remote Procedurescan occur: PL/SQL user-defined exceptions, which must be declared using the keyword EXCEPTION PL/SQL … procedures, you can trap these messages by writing an exception handler such as the following BEGIN … ... EXCEPTION WHEN ZERO_DIVIDE THEN /*... handle the exception */ END; Notice that the WHEN clause … requires

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Integrity Constraints

Reporting Constraint Exceptionsall exception rows into a specified table. You must create an appropriate exceptions report table to … . You can create an exception table by executing the UTLEXCPT.SQL script or the UTLEXPT1.SQL script … exception report table and the master table to list the actual rows that violate a specific constraint … for the exception

Database Administrator's Guide, 11g Release 1 (11.1)

Using Schedules

Altering Schedules… Altering a schedule changes the definition of the schedule. With the exception of schedule name

Database Administrator's Guide, 11g Release 1 (11.1)

Using Events

Passing Event Messages into an Event-Based Job=> 'EVENT_MESSAGE'). dbms_scheduler.enable ('my_prog'); exception when others then raise. end. / begin … => 'my_evt_sch', enabled => true, auto_Drop => false). exception when others then raise. end. /

Database Administrator's Guide, 11g Release 1 (11.1)

Using Windows

Altering Windowsthe exception of WINDOW_NAME, all the attributes of a window can be changed when it is altered. The

Database Administrator's Guide, 11g Release 1 (11.1)

Using Jobs

Altering JobsEnterprise Manager. All jobs can be altered, and, with the exception of the job name, all job attributes can

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Integrity Constraints

Enabling Constraints… However, while the constraint is disabled such a row can be inserted. This row is known as an exception

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Resumable Space Allocation

How Resumable Space Allocation WorksSession Suspended alert is cleared. A suspended statement can be forced to throw the exception using … returns the exception to the user. A resumable statement can be suspended and resumed multiple times during execution.

Database Administrator's Guide, 11g Release 1 (11.1)

Purging Pending Rows from the Data Dictionary

Purging Pending Rows from the Data Dictionarydeletes entries in these states. The only exception is when recovery discovers a forced transaction

Database Administrator's Guide, 11g Release 1 (11.1)

Viewing Information About Database Links

Determining Which Link Connections Are Open, with one exception: Column Which Views? Description DB_LINK All The name of the database link

Database Administrator's Guide, 11g Release 1 (11.1)

About the Oracle Database Fault Diagnosability Infrastructure

About Incidents and Problemserrors, such as ORA-07445 (operating system exception) or ORA-04031 (out of memory in the shared pool

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Tablespaces

Temporary Tablespacestablespace. Note: The exception to the preceding statement is a temporary table. When you create a

Database Administrator's Guide, 11g Release 1 (11.1)

Enabling and Disabling Remote External Jobs

Installing, Configuring, and Starting the Scheduler Agentexception to accommodate the Scheduler agent. Register the Scheduler agent with a database that is

Database Administrator's Guide, 11g Release 1 (11.1)

About Creating an Oracle Database

Planning for Database Creationan exception. Oracle Database Globalization Support Guide Consider what time zones your database





Was this page helpful?

Integrated Cloud Applications & Platform Services