Oracle9i Database Search Results: 'RAISE'
(Release 2 (9.2))

Your search for RAISE matched 1278 topics across 61 books. In the list below, select a book title to see the matching topics in that book.

Featured Results (A-Z)

Administrator's Guide (12 matching topics)

Application Developer's Guide - Fundamentals (32 matching topics)

Concepts (6 matching topics)

Performance Tuning Guide and Reference (1 matching topics)

PL/SQL User's Guide and Reference (151 matching topics)

%FOUND Attribute: Has a Row Been Fetched?

%NOTFOUND Attribute: Has a Fetch Failed?

%ROWCOUNT Attribute: How Many Rows Affected So Far?

%ROWCOUNT Attribute: How Many Rows Fetched So Far?

Actual Versus Formal Subprogram Parameters

Advantages of PL/SQL Exceptions

Algorithms

Assigning Character Values

Autonomous Versus Nested Transactions

Avoiding Collection Exceptions

Avoiding Errors - Doing Independent Units of Work with Autonomous Transactions

Avoiding Errors with Cursor Variables

basic_loop_statement - LOOP Statements

Block Structure

Calling External Subprograms

CASE Statement

Catching Unhandled Exceptions

Closing a Cursor

Closing a Cursor Variable

Closing the Cursor Variable

Conditional Control

Continuing after an Exception Is Raised

Declaring Records

Decreasing the Size of a Collection (TRIM Method)

Defining Your Own Error Messages: Procedure RAISE_APPLICATION_ERROR

Defining Your Own PL/SQL Exceptions

Deleting Collection Elements (DELETE Method)

Entering and Exiting - Doing Independent Units of Work with Autonomous Transactions

Error Handling

Error Handling in the Wrap Utility

Example - exception_name

Example - error_number

Example: Possible Exceptions for Collection Assignments - Assigning Collections

Examples - := | DEFAULT

Examples - type_name

Examples - USING ...

Examples - %ROWCOUNT Attribute

Examples - WHERE search_condition

Examples - CASE Statement

Examples - SQL

EXCEPTION - Blocks

Exceptions

exception_handler - Functions

exception_handler - Blocks

exception_handler - Procedures

Fetching Across Commits - Overview of Transaction Processing in PL/SQL

Fetching from a Cursor Variable

Fetching from the Cursor Variable

Fetching with a Cursor

Functions

Guidelines for PL/SQL Conditional Statements

Guidelines for Using Implicit Cursor Attributes

Handling Exceptions in Table Functions

Handling Exceptions Raised in Declarations

Handling Exceptions Raised in Handlers

Handling FORALL Exceptions with the %BULK_EXCEPTIONS Attribute

Handling PL/SQL Errors

Handling Raised PL/SQL Exceptions

How FORALL Affects Rollbacks

How Globalization Settings Affect VARCHAR2 Keys for Associative Arrays

How Oracle Does Implicit Rollbacks

How PL/SQL Exceptions Are Raised

How PL/SQL Exceptions Propagate

How PL/SQL Treats Uninitialized Objects

IF-THEN-ELSE Statement

Increasing the Size of a Collection (EXTEND Method)

Iteration Schemes

Keyword and Parameter Description - CASE Statement

Limiting the Rows for a Bulk FETCH Operation with the LIMIT Clause

List of PL/SQL Reserved Words

lower_bound .. upper_bound - LOOP Statements

Manipulating Records

NOT NULL - Records

NOT NULL - Constants and Variables

Object Type Example: Bank_Account

Object Type Example: Stack

Object Type Example: Ticket_Booth

Opening a Cursor Variable

Overview of PL/SQL Error Handling

Packaging PL/SQL Subprograms Together

Parameter SELF - Components of an Object Type

Performing DML Operations on Table Functions

PL/SQL Block in a C Program

PL/SQL Language Elements

PL/SQL Naming Conventions

PLS_INTEGER

Predefined PL/SQL Exceptions

Procedures

RAISE Statement

Raising Exceptions with the RAISE Statement

RAW and LONG RAW Values

Redeclaring Predefined Exceptions

Related Topics - WHEN

Reraising a PL/SQL Exception

Restrictions - sql_statement

Retrieving the Error Code and Error Message: SQLCODE and SQLERRM

Retrying a Transaction

Returning Results from Table Functions

ROWID and UROWID

Scope Rules for PL/SQL Exceptions

Searched CASE Statement

Selecting Character Values

Sequential Control

Sequential Control: GOTO and NULL Statements

Some Examples of Dynamic SQL

Some Examples of Package Features

SQLCODE Function

statement - Blocks

Statement-Level Rollbacks

Subprograms

Syntax - RAISE Statement

TRIM - Collection Methods

Understanding PL/SQL Procedures

Understanding Subprogram Parameter Aliasing

Understanding The Package Body

Undoing Changes with ROLLBACK

Undoing Partial Changes with SAVEPOINT

Unnecessary NOT NULL Constraints - Reasons for PL/SQL Performance Problems

Usage Notes - variable_name

Usage Notes - host_cursor_variable_name

Usage Notes - error_number

Usage Notes - SQLCODE Function

Usage Notes - SQL

Usage Notes - WORK

Usage Notes - %ROWCOUNT Attribute

Usage Notes - type_name

Usage Notes - WHEN

Usage Notes - label_name

Usage Notes - TRIM

Usage Notes - variable_name

Usage Notes - label_name

Usage Notes - while_loop_statement

Usage Notes - PRAGMA

Usage Notes - type_name

Usage Notes - variable_declaration

Usage Notes - := | DEFAULT

Usage Notes - exception_name

Usage Notes - expression

Usage Notes - WORK

Usage Notes - savepoint_name

Usage Notes - variable_name

Using Collection Methods

Using Cursor FOR Loops

Using NOT NULL

Using Subtypes

Using the OUT Mode

What Are Subprograms?

What Is a Recursive Subprogram?

WHEN - Exceptions

WHERE CURRENT OF cursor_name - UPDATE Statement

WHERE CURRENT OF cursor_name - DELETE Statement

Reference (5 matching topics)

SQL Reference (22 matching topics)

Other Results (A-Z)

Advanced Replication (9 matching topics)

Application Developer's Guide - Advanced Queuing (10 matching topics)

Application Developer's Guide - Large Objects (LOBs) (20 matching topics)

Application Developer's Guide - Object-Relational Features (5 matching topics)

Application Developer's Guide - Workspace Manager (36 matching topics)

COM Automation Feature Developer's Guide (1 matching topics)

Data Cartridge Developer's Guide (21 matching topics)

Data Warehousing Guide (4 matching topics)

Dynamic Services User's and Administrator's Guide (4 matching topics)

Enterprise Manager Administrator's Guide (6 matching topics)

Enterprise Manager Concepts Guide (1 matching topics)

Enterprise Manager Event Test Reference Manual (4 matching topics)

Error Messages (47 matching topics)

Getting Started for Windows (3 matching topics)

Globalization Support Guide (3 matching topics)

Heterogeneous Connectivity Administrator's Guide (1 matching topics)

Intelligent Agent User's Guide (15 matching topics)

interMedia User's Guide and Reference (173 matching topics)

Internet Directory Application Developer's Guide (41 matching topics)

Java Developer's Guide (2 matching topics)

Java Stored Procedures Developer's Guide (4 matching topics)

JDBC Developer's Guide and Reference (5 matching topics)

Label Security Administrator's Guide (9 matching topics)

Migration (7 matching topics)

Migration Workbench Reference Guide for Informix Dynamic Server 7.3 Migrations (6 matching topics)

Migration Workbench Reference Guide for Microsoft Access 2.0, 95, 97, 2000 Migrations (4 matching topics)

Migration Workbench Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations (9 matching topics)

Migration Workbench Reference Guide for MySQL 3.22, 3.23 Migrations (1 matching topics)

New Features (2 matching topics)

OLAP Developer's Guide to the OLAP API (1 matching topics)

OLAP Developer's Guide to the OLAP DML (1 matching topics)

Oracle C++ Call Interface Programmer's Guide (6 matching topics)

Oracle Call Interface Programmer's Guide (25 matching topics)

Oracle Objects for OLE (32 matching topics)

Performance Planning (1 matching topics)

Pro*C/C++ Precompiler Programmer's Guide (16 matching topics)

Pro*COBOL Precompiler Programmer's Guide (10 matching topics)

Pro*PL/1 Supplement to the Oracle Precompilers Guide (4 matching topics)

Real Application Clusters Real Application Clusters Guard I - Concepts and Administration (1 matching topics)

Recovery Manager Reference (1 matching topics)

Recovery Manager User's Guide (2 matching topics)

Replication Management API Reference (13 matching topics)

Sample Schemas (4 matching topics)

Security Overview (1 matching topics)

SQL*Module for Ada Programmer's Guide (5 matching topics)

SQL*Plus User's Guide and Reference (3 matching topics)

SQLJ Developer's Guide and Reference (13 matching topics)

Streams (20 matching topics)

Supplied Java Packages Reference (71 matching topics)

Supplied PL/SQL Packages and Types Reference (241 matching topics)

Text Reference (12 matching topics)

Utilities (4 matching topics)

XML API Reference - XDK and Oracle XML DB (86 matching topics)

XML Developer's Kits Guide - XDK (23 matching topics)

Copyright © 2013, Oracle. All rights reserved.