Book HomeBook HomeSearch this book

Symbols | A | B | C | D | E | F | G | H | I | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z

Index: E

ECS (execution call stack) : 5.28.8. Accessing the PLVtrc execution call stack (ECS)
ecs_string function
5.28.8. Accessing the PLVtrc execution call stack (ECS)
21.2.4.7. Retrieving stack contents
elapsed function
5.27.5. Retrieving and displaying elapsed time
14.3. Retrieving and Displaying the Elapsed Time
elapsed time
14.3. Retrieving and Displaying the Elapsed Time
5.27. PLVtmr: Program Performance Analyzer
elapsed_message function
5.27.5. Retrieving and displaying elapsed time
14.3.1. elapsed_message Function
elements
arrays : (see arrays)
packages : (see packages)
empty procedure : 8.6.1. Improving the Delete Process
empty tables
5.25.2. The empty PL/SQL tables
8.6. Emptying Tables with PLVtab
ENABLE procedure : 7.4. Controlling Output from p
enabling access : (see access)
encapsulating data : (see access, package elements)
encapsulation : (see modularization)
END : (see BEGIN-END block syntax)
end-of-file marker : 13.5.1. Reading the Next Line
endcmnt function : 17.5.3.1. Functions to scan USER_SOURCE
ends_multiline_comment function : 5.16.1. Analyzing PL/SQL string content
entity-relationship diagram (ERD) : 1.6.1.5. Isolate volatile areas of functionality
equal sign (=) : 16.2.3.3. Default values for string functions
ERD (entity-relationship diagram) : 1.6.1.5. Isolate volatile areas of functionality
err procedure
5.29.4. Displaying compile errors
11.3.1. Setting Individual Elements of Current Object
15.2. Displaying Compile Errors
15.4.2. Implementing the SHOW ERRORS Alternative
errm function
5.3.6. Miscellaneous programs
6.4.2. Obtaining the Error Message
6.6. The Predefined Constants
error codes : 22.1.6.1. The handle procedure
error messages : 22.1.6.4. Defining error messages with PLVmsg
errors
(see also exceptions)
1.6.3.2. The exception section
3.7. Handling Program Assumptions
6.4.2. Obtaining the Error Message
13.1.4. Handling UTL_FILE Errors
bailout : 22.1.10. Bailing Out with PLVexc
boundary checking : 3.8.1. When the num_in Argument Is 0
compiling
5.29.4. Displaying compile errors
15.1.2. What SHOW ERRORS Does
consistent data on : 22.2.1.1. Recording consistent error data
messages : (see messages)
PLVmsg with : 9.5. Integrating PLVmsg with Error Handling
recording : 22.1.7. Recording Errors
rollbacks on : 22.1.8. Rolling Back When an Exception Occurs
UTL_FILE package : 13.1.4. Handling UTL_FILE Errors
exc_section procedure : 13.9. Handling File Errors with PLVfile
EXCEPTION_INIT pragma : 5.10.2. Package-based exceptions
exceptions
(see also errors)
A.1.3. Exception Handling
A.2.3. Exception Handling
3.7. Handling Program Assumptions
5.10. PLVexc: Exception Handling
13.1.4. Handling UTL_FILE Errors
16.3.5. Using the PLVexc Exception Handler
21.1.2.1. Using put_line
22. Exception Handling
assertion_failure : 5.3.5. Assertion routines
file : 13.9. Handling File Errors with PLVfile
insert failure : 5.15.1. Package constants and exceptions
INVALID_PATH : 13.9. Handling File Errors with PLVfile
list_full : 5.18.1. Package exceptions
list_undefined : 5.18.1. Package exceptions
messages : (see messages)
NO_DATA_FOUND : 21.2.5. Using PLVtrc
NO_SUCH_TABLE : 22.1.2. Package-Based Exceptions
out_of_bounds : 5.18.1. Package exceptions
package exception section : 1.6.3.2. The exception section
PLVmsg with : 9.5. Integrating PLVmsg with Error Handling
process halted : 22.1.10. Bailing Out with PLVexc
recording
22.1.7. Recording Errors
22.3.3.3. Recording the exception
resulting action options : 22.1.4. Exception Handling Actions
SNAPSHOT_TOO_OLD : 22.1.2. Package-Based Exceptions
UTL_FILE package : 13.1.4. Handling UTL_FILE Errors
VALUE_ERROR
A.1.3. Exception Handling
A.2.3. Exception Handling
13.1.4. Handling UTL_FILE Errors
WRITE_ERROR : 13.1.4. Handling UTL_FILE Errors
execsql procedure
5.9.2. Controlling execution of dynamic SQL
19.5.8. Controlling Execution of Dynamic SQL
execute authority
1.3.5. Guaranteeing Transaction Integrity
4.3.6. Granting Access to PL/Vision
execute procedure
5.9.3. Bundled, low-level operations
19.5.6.4. Passthrough elements
EXECUTE procedure : 19.5.4. Checking feedback on DML
execute_and_close procedure
5.9.3. Bundled, low-level operations
19.5.6.2. Execute and close
execute_and_fetch procedure
5.9.3. Bundled, low-level operations
19.5.6.4. Passthrough elements
executing function : 5.9.2. Controlling execution of dynamic SQL
execution privileges, DDL : 19.4.1. DDL Operations
execution time : (see performance)
existence checking, files : 5.11.6. Checking for file existence
extensions
file : 2.4. Organizing Package Source Code
package element names : 2.3.3. Avoiding Superfluous Naming Elements


Symbols | A | B | C | D | E | F | G | H | I | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z
The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference