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

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