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

Index: E

ECS (execution call stack): 5.28.8. Accessing the PLVtrc execution call stack (ECS), Advanced Oracle PL/SQL Programming with Packages

EJB (Enterprise JavaBeans)

1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
9.1. Oracle8i and Java, Guide to Oracle8i Features

EJBs (Enterprise Java Beans(TM)): 1.3.7. Java, Oracle Web Applications

ELSE keyword: (see IF statements)

ELSIF keyword: (see IF statements)

EMPTY_BLOB function

7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
13.2.2. The EMPTY_BLOB function, Oracle PL/SQL Programming

EMPTY_CLOB function

7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
13.2.3. The EMPTY_CLOB function, Oracle PL/SQL Programming

EMP_SURVEY Package: 8.2.4. The EMP_SURVEY Package, Oracle Web Applications

ENABLE column, *_POLICIES data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

ENABLE procedure

7.4. Controlling Output from p, Advanced Oracle PL/SQL Programming with Packages
6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages
6.1.2.1. The DBMS_OUTPUT.ENABLE procedure, Oracle Built-in Packages
C.9.2. The ENABLE procedure, Oracle PL/SQL Programming

ENABLE_POLICY procedure, DBMS_RLS package

7.3.2. DBMS_RLS Programs, Guide to Oracle8i Features
7.3.5. ENABLE_POLICY: Enabling or Disabling a Policy, Guide to Oracle8i Features

END: (see BEGIN-END block syntax)

END IF: (see IF statements)

END LOOP keywords: (see loops)

END command, PL/SQL: 6.1.1. Procedures, Oracle Web Applications

END label

15.4.4. The END Label, Oracle PL/SQL Programming
15.5.3. The END Label, Oracle PL/SQL Programming

END_INSTANTIATION procedure

15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
15.4.2.3. The DBMS_OFFLINE_OG.END_INSTANTIATION procedure, Oracle Built-in Packages

END_LOAD procedure

14.3.1.1. DBMS_OFFLINE_SNAPSHOT programs, Oracle Built-in Packages
14.3.2.2. The DBMS_OFFLINE_SNAPSHOT.END_LOAD procedure, Oracle Built-in Packages
15.4.1. Getting Started with DBMS_OFFLINE_OG, Oracle Built-in Packages
15.4.2.4. The DBMS_OFFLINE_OG.END_LOAD procedure, Oracle Built-in Packages

END_TABLE_REORGANIZATION procedure

14.1.1. Getting Started with DBMS_SNAPSHOT, Oracle Built-in Packages
14.1.5.2. The DBMS_SNAPSHOT.END_TABLE_REORGANIZATION procedure (Oracle8 only) , Oracle Built-in Packages

ENQUEUE option, GRANT_QUEUE_PRIVILEGE procedure: 7.6.3.1. GRANT_QUEUE_PRIVILEGE: Granting queue-level privileges, Guide to Oracle8i Features

ENQUEUE procedure

5.4.1.1. The DBMS_AQ.ENQUEUE procedure, Oracle Built-in Packages
C.3.1.1. The ENQUEUE procedure, Oracle PL/SQL Programming

ENQUEUE procedure, DBMS_AQ package

6.2. Database-Level Event Triggers, Guide to Oracle8i Features
6.2.1.2. Tracking logins to the database, Guide to Oracle8i Features

ENQUEUE_ANY option, GRANT_SYSTEM_PRIVILEGE procedure: 7.6.2.1. GRANT_SYSTEM_PRIVILEGE: Granting system-level privileges, Guide to Oracle8i Features

ER (entity-relationship) model: 18.1.4.3. Inheritance , Oracle PL/SQL Programming

ERASE procedure

8.1.1. DBMS_LOB Programs, Oracle Built-in Packages
8.3.3.3. The DBMS_LOB.ERASE procedure, Oracle Built-in Packages
C.6.4. The ERASE procedure, Oracle PL/SQL Programming

ERD (entity-relationship diagram): 1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages

ERP(enterprise resource planning): 1. Introduction, Oracle Web Applications

ERROR_IO return code, DBMS_PROFILER package: 7.1.4. Profiler Return Codes, Guide to Oracle8i Features

ERROR_PARM return code, DBMS_PROFILER package: 7.1.4. Profiler Return Codes, Guide to Oracle8i Features

ERROR_VERSION return code, DBMS_PROFILER package: 7.1.4. Profiler Return Codes, Guide to Oracle8i Features

ESL (EnterpriseSync Lite): 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications

EXCEPTION keyword

8.3.2. Named Programmer-Defined Exceptions, Oracle PL/SQL Programming
8.6. Handling Exceptions, Oracle PL/SQL Programming

EXCEPTION_INIT pragma

5.10.2. Package-based exceptions, Advanced Oracle PL/SQL Programming with Packages
8.3.3.1. The EXCEPTION_INIT pragma, Oracle PL/SQL Programming

EXCLUDE_PUSH function

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.6.1. The DBMS_DEFER_SYS.EXCLUDE_PUSH function (Oracle8 only), Oracle Built-in Packages

EXECUTE IMMEDIATE statement, native dynamic SQL

1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ), Guide to Oracle8i Features
3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
4.2.1. The EXECUTE IMMEDIATE Statement, Guide to Oracle8i Features
4.6.2. Error Handling, Guide to Oracle8i Features

EXECUTE authority: 4.6.1. Sharing NDS Programs with Invoker Rights, Guide to Oracle8i Features

EXECUTE command

C.14.6. The EXECUTE function, Oracle PL/SQL Programming
23.1.1. Executing Procedures, Oracle PL/SQL Programming
23.5.3. Changing Stored Objects, Oracle PL/SQL Programming
EXECUTE_AND_FETCH command: C.14.7. The EXECUTE_AND_FETCH function, Oracle PL/SQL Programming

EXECUTE function (DBMS_SQL)

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.6.1. The DBMS_SQL.EXECUTE function, Oracle Built-in Packages
executing: 2.3.6.1. The DBMS_SQL.EXECUTE function, Oracle Built-in Packages
immediate execution: 2.3.3.1. The DBMS_SQL.PARSE procedure, Oracle Built-in Packages

EXECUTE permission: 6.1.6. Permissions, Oracle Web Applications

EXECUTE procedure: 19.5.4. Checking feedback on DML, Advanced Oracle PL/SQL Programming with Packages

EXECUTE procedure (DBMS_DEFER_SYS)

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.5.2. The DBMS_DEFER_SYS.EXECUTE procedure, Oracle Built-in Packages

EXECUTE_AND_FETCH function

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.7.2. The DBMS_SQL.EXECUTE_AND_FETCH function, Oracle Built-in Packages
troubleshooting: 2.3.8. Retrieving Values , Oracle Built-in Packages

EXECUTE_CATALOG_ROLE: 8.1. FGAC Components, Guide to Oracle8i Features

EXECUTE_DDL procedure

15.3.1.1. DBMS_REPCAT programs, Oracle Built-in Packages
15.3.3.4. The DBMS_REPCAT.EXECUTE_DDL procedure, Oracle Built-in Packages

EXECUTE_ERROR procedure

17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages
17.2.4.4. The DBMS_DEFER_SYS.EXECUTE_ERROR procedure, Oracle Built-in Packages

EXECUTE_ERROR_AS_USER procedure: 17.2.1.1. DBMS_DEFER_SYS programs, Oracle Built-in Packages

EXEC_DDL_STATEMENT procedure

10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.9. The DBMS_UTILITY.EXEC_DDL_STATEMENT procedure, Oracle Built-in Packages

EXISTS function

10.8.2.3. The EXISTS function, Oracle PL/SQL Programming
19.6.3. EXISTS(i), Oracle PL/SQL Programming

EXIT statement

7.2.1. Terminating a Simple Loop: EXIT and EXIT WHEN, Oracle PL/SQL Programming

7.7.2.2. EXIT and EXIT WHEN statements, Oracle PL/SQL Programming

EXIT WHEN statement

7.2.1. Terminating a Simple Loop: EXIT and EXIT WHEN, Oracle PL/SQL Programming
7.2.2. Emulating a REPEAT UNTIL Loop, Oracle PL/SQL Programming
7.7.2.2. EXIT and EXIT WHEN statements, Oracle PL/SQL Programming
7.2.1. Terminating a Simple Loop: EXIT and EXIT WHEN, Oracle PL/SQL Programming

with loop labels: 7.6.1.2. Loop termination using labels, Oracle PL/SQL Programming

EXP function: 13.1.9. The EXP function, Oracle PL/SQL Programming

EXPLAIN PLAN statement: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming

EXPORT_CLASS procedure, DBMS_JAVA package

9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features
9.7.4. EXPORT_SOURCE, _RESOURCE, and _CLASS: Exporting Schema Objects, Guide to Oracle8i Features

EXPORT_RESOURCE procedure, DBMS_JAVA package

9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features
9.7.4. EXPORT_SOURCE, _RESOURCE, and _CLASS: Exporting Schema Objects, Guide to Oracle8i Features

EXPORT_SOURCE procedure, DBMS_JAVA package

9.7. Using DBMS_JAVA and DBMS_JAVA_TEST, Guide to Oracle8i Features
9.7.4. EXPORT_SOURCE, _RESOURCE, and _CLASS: Exporting Schema Objects, Guide to Oracle8i Features

EXTEND procedure: 19.6.4. EXTEND [ (n [,i] ) ], Oracle PL/SQL Programming

adding collection elements: 19.4.3.1. Adding elements using EXTEND, Oracle PL/SQL Programming

EXTERNAL clause: 21.3.2. EXTERNAL: Creating the PL/SQL Body, Oracle PL/SQL Programming

EXTERNAL_PROCEDURE_LISTENER listener: 21.2.1. Step 1: Set Up the Listener, Oracle PL/SQL Programming

Enterprise Java Beans(TM) (EJBs): 1.3.7. Java, Oracle Web Applications

Enterprise JavaBeans (EJB)

1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
9.1. Oracle8i and Java, Guide to Oracle8i Features

Enterprise Manager/Performance Pack product: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming

Enterprise Resource Planning (ERP): 1.1. The Internet Grows Up, Oracle Web Applications

EnterpriseSync Lite (ESL): 1.3.8.2. EnterpriseSync Lite, Oracle Web Applications

Eudora

1.3.1. The Internet File System, Oracle Web Applications
1.3.8.2. EnterpriseSync Lite, Oracle Web Applications

Excel: 1.3.9.1. Text data, Oracle Web Applications

e-commerce: 1.1. The Internet Grows Up, Oracle Web Applications

e-commerce applications: 1.1. The Internet Grows Up, Oracle Web Applications

ecs_string function

5.28.8. Accessing the PLVtrc execution call stack (ECS), Advanced Oracle PL/SQL Programming with Packages
21.2.4.7. Retrieving stack contents, Advanced Oracle PL/SQL Programming with Packages

editing table rows: 10.5. Referencing and Modifying PL/SQL Table Rows, Oracle PL/SQL Programming

effdsql.tst : 2.4.5. Improving the Performance of Dynamic SQL, Oracle Built-in Packages

egister.sql : 7.3.3. The set_stats Procedure, Oracle Built-in Packages

elapsed function

5.27.5. Retrieving and displaying elapsed time, Advanced Oracle PL/SQL Programming with Packages
14.3. Retrieving and Displaying the Elapsed Time, Advanced Oracle PL/SQL Programming with Packages

elapsed time: 14.3. Retrieving and Displaying the Elapsed Time, Advanced Oracle PL/SQL Programming with Packages

elapsed time, code: 5.27. PLVtmr: Program Performance Analyzer, Advanced Oracle PL/SQL Programming with Packages

elapsed time, returning: 10.1.2.14. The DBMS_UTILITY.GET_TIME function, Oracle Built-in Packages

elapsed_message function

5.27.5. Retrieving and displaying elapsed time, Advanced Oracle PL/SQL Programming with Packages
14.3.1. elapsed_message Function, Advanced Oracle PL/SQL Programming with Packages

electronic data exchange: 1.2. Current Web Techniques Are Inadequate, Oracle Web Applications

elements

arrays: (see arrays)
packages: (see packages)

email, sending with external procedures: 21.7.2. Example: Sending Email, Oracle PL/SQL Programming

embedded PL/SQL: (see stored functions, PL/SQL)

embedding

trace calls in programs: 26.5. Quick-and-Dirty Tracing, Oracle PL/SQL Programming

embedding quotation marks: 2.3.1. Embedding Single Quotes Inside a String, Oracle PL/SQL Programming

empfetch package

(see also specific program names)
2.5.6.4. Using array processing to fetch, Oracle Built-in Packages

empfetch.spp : 2.5.6.4. Using array processing to fetch, Oracle Built-in Packages

empfetch.tst : 2.5.6.4. Using array processing to fetch, Oracle Built-in Packages

empty procedure: 8.6.1. Improving the Delete Process, Advanced Oracle PL/SQL Programming with Packages

empty tables

5.25.2. The empty PL/SQL tables, Advanced Oracle PL/SQL Programming with Packages
8.6. Emptying Tables with PLVtab, Advanced Oracle PL/SQL Programming with Packages

enable parameter, ADD_POLICY procedure: 7.3.2. DBMS_RLS Programs, Guide to Oracle8i Features

enabling access: (see access)

ename_val procedure: 2.5.6.4. Using array processing to fetch, Oracle Built-in Packages

encapsulating calculations: 17.8.1. Encapsulating Calculations , Oracle PL/SQL Programming

encapsulating data: (see access, package elements)

encapsulation

2.5.1. Building an Autonomous Logging Mechanism, Guide to Oracle8i Features
18.1.5.2. Encapsulation , Oracle PL/SQL Programming
of data structure access: 1.7.2. Synchronize Program and Data Structures, Oracle PL/SQL Programming
of persistent objects: 18.2.2.2. DDL usage , Oracle PL/SQL Programming
on object views: 20.2.1.1. The "don't use" argument, Oracle PL/SQL Programming

encapsulation, packages for: 1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages

enclosed block: (see nested blocks)

encrypted data, packing into message buffers: 3.1.4.2. The DBMS_PIPE.PACK_MESSAGE_RAW procedure, Oracle Built-in Packages

encrypting code: 23.7. Encrypting Stored Code, Oracle PL/SQL Programming

end-of-file marker: 13.5.1. Reading the Next Line, Advanced Oracle PL/SQL Programming with Packages

end-of-line markers: (see newline markers)

endcmnt function: 17.5.3.1. Functions to scan USER_SOURCE, Advanced Oracle PL/SQL Programming with Packages

ends_multiline_comment function: 5.16.1. Analyzing PL/SQL string content, Advanced Oracle PL/SQL Programming with Packages

enqueue options record type: 5.3.7. Enqueue Options Record Type, Oracle Built-in Packages

enqueue procedure: 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages

enqueue_high procedure: 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages

enqueue_low procedure: 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages

enqueue_medium procedure: 5.7.2. Working with Prioritized Queues, Oracle Built-in Packages

enqueuing: 5.4.1.1. The DBMS_AQ.ENQUEUE procedure, Oracle Built-in Packages

AQ features for: 5.1.2. Enqueue Features, Oracle Built-in Packages

delay value: 5.3.6. Message Properties Record Type, Oracle Built-in Packages

time of: 5.3.6. Message Properties Record Type, Oracle Built-in Packages

transactions and

5.1.3. Dequeue Features, Oracle Built-in Packages
5.3.7. Enqueue Options Record Type, Oracle Built-in Packages

enqueuing messages: 1.3.10.3. Enqueue and dequeue messages to/from a queue, Oracle Web Applications

enterprise resource planning (ERP) systems: 1. Introduction, Oracle Web Applications

entity-relationship (ER) model: 18.1.4.3. Inheritance , Oracle PL/SQL Programming

entity-relationship diagram (ERD): 1.6.1.5. Isolate volatile areas of functionality, Advanced Oracle PL/SQL Programming with Packages

environment, user: 13.3.9. The USERENV function, Oracle PL/SQL Programming

equal sign (=): 16.2.3.3. Default values for string functions , Advanced Oracle PL/SQL Programming with Packages

equality

objects, testing for: 18.3.6.2. Equality comparisons, Oracle PL/SQL Programming

erasing: (see deleting)

err procedure

5.29.4. Displaying compile errors, Advanced Oracle PL/SQL Programming with Packages
11.3.1. Setting Individual Elements of Current Object, Advanced Oracle PL/SQL Programming with Packages
15.2. Displaying Compile Errors, Advanced Oracle PL/SQL Programming with Packages
15.4.2. Implementing the SHOW ERRORS Alternative, Advanced Oracle PL/SQL Programming with Packages

errm function

5.3.6. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
6.4.2. Obtaining the Error Message, Advanced Oracle PL/SQL Programming with Packages
6.6. The Predefined Constants, Advanced Oracle PL/SQL Programming with Packages

error codes: 22.1.6.1. The handle procedure, Advanced Oracle PL/SQL Programming with Packages

error handling, native dynamic SQL: 4.6.2. Error Handling, Guide to Oracle8i Features

error messages: 22.1.6.4. Defining error messages with PLVmsg, Advanced Oracle PL/SQL Programming with Packages

"attribute expression within SQL expression": 6.9. Cursor Attributes, Oracle PL/SQL Programming

"cursor already open"

6.5. Opening Cursors, Oracle PL/SQL Programming
6.9.4. The %ISOPEN Attribute, Oracle PL/SQL Programming

"expression is inappropriate": 6.4.1. The Cursor Name, Oracle PL/SQL Programming

"fetch out of sequence": 6.11.1. Releasing Locks with COMMIT, Oracle PL/SQL Programming

"function returned without value": 15.5.8.3. No RETURN is executed, Oracle PL/SQL Programming

"maximum open cursors exceeded": 6.8.1. Maximum Number of Cursors, Oracle PL/SQL Programming

"wrong number of values in the INTO list": 6.6.1. Matching Column List with INTO Clause, Oracle PL/SQL Programming

"illegal GOTO statement": 5.2.1.2. Target labels and scope of GOTO, Oracle PL/SQL Programming

SQLERRM function: 13.3.6. The SQLERRM function, Oracle PL/SQL Programming

error stack, returning: 10.1.2.11. The DBMS_UTILITY.FORMAT_ERROR_STACK function, Oracle Built-in Packages

errors

(see also exceptions)

1.6.3.2. The exception section, Advanced Oracle PL/SQL Programming with Packages

3.7. Handling Program Assumptions, Advanced Oracle PL/SQL Programming with Packages

6.4.2. Obtaining the Error Message, Advanced Oracle PL/SQL Programming with Packages

13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

2.4.6. Problem-Solving Dynamic SQL Errors, Oracle Built-in Packages

8. Exception Handlers, Oracle PL/SQL Programming

PLVmsg with: 9.5. Integrating PLVmsg with Error Handling, Advanced Oracle PL/SQL Programming with Packages

UTL_FILE package: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

bailout: 22.1.10. Bailing Out with PLVexc, Advanced Oracle PL/SQL Programming with Packages

boundary checking: 3.8.1. When the num_in Argument Is 0, Advanced Oracle PL/SQL Programming with Packages

caused by implicit cursors: 6.3.2.2. Vulnerability to data errors, Oracle PL/SQL Programming

codes for: (see SQLCODE)

communication from server to client: 8.7. Client-Server Error Communication, Oracle PL/SQL Programming

compiling

5.29.4. Displaying compile errors, Advanced Oracle PL/SQL Programming with Packages
15.1.2. What SHOW ERRORS Does, Advanced Oracle PL/SQL Programming with Packages

consistent data on: 22.2.1.1. Recording consistent error data, Advanced Oracle PL/SQL Programming with Packages

dynamic SQL parsing: (see dynamic SQL, troubleshooting)

handling: 1.4.3.9. Error handling, Oracle PL/SQL Programming

messages: (see messages)

recording: 22.1.7. Recording Errors, Advanced Oracle PL/SQL Programming with Packages

rollbacks on: 22.1.8. Rolling Back When an Exception Occurs, Advanced Oracle PL/SQL Programming with Packages

viewing in SQL*Plus: 23.5.4. Viewing Compilation Errors in SQL*Plus, Oracle PL/SQL Programming

violation of RESTRICT_REFERENCES pragma: 17.5.1.1. Pragma violation errors, Oracle PL/SQL Programming

errors, trapping system: 6.2.1.3. Trapping system errors, Guide to Oracle8i Features

errpos.sql : 2.3.10.1. The DBMS_SQL.LAST_ERROR_POSITION function, Oracle Built-in Packages

errstk.stk : 10.1.2.11. The DBMS_UTILITY.FORMAT_ERROR_STACK function, Oracle Built-in Packages

event journals: 5.1.1. General Features, Oracle Built-in Packages

event level, tracing: 26.1.2. Turning On the Trace, Oracle PL/SQL Programming

event levels: (see tracing, event levels)

exc_section procedure: 13.9. Handling File Errors with PLVfile, Advanced Oracle PL/SQL Programming with Packages

exception

WRITE_ERROR: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

exception handling, Java: 9.8.5. Exception Handling with Java, Guide to Oracle8i Features

exception queues

5.1.5. A Glossary of Terms, Oracle Built-in Packages
5.3.6. Message Properties Record Type, Oracle Built-in Packages
5.5.1.2. The DBMS_AQADM.CREATE_QUEUE_TABLE procedure, Oracle Built-in Packages

exception section, PL/SQL: 6.1. Structured Programming in PL/SQL , Oracle Web Applications

exception tracing: 7.2.3. Controlling Trace File Contents, Guide to Oracle8i Features

exceptions

(see also errors)

A.1.3. Exception Handling, Advanced Oracle PL/SQL Programming with Packages

A.2.3. Exception Handling, Advanced Oracle PL/SQL Programming with Packages

3.7. Handling Program Assumptions, Advanced Oracle PL/SQL Programming with Packages

5.10. PLVexc: Exception Handling, Advanced Oracle PL/SQL Programming with Packages

13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

16.3.5. Using the PLVexc Exception Handler, Advanced Oracle PL/SQL Programming with Packages

21.1.2.1. Using put_line, Advanced Oracle PL/SQL Programming with Packages

22. Exception Handling, Advanced Oracle PL/SQL Programming with Packages

1.4.3.9. Error handling, Oracle PL/SQL Programming

8. Exception Handlers, Oracle PL/SQL Programming

CURSOR_ALREADY_OPEN: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

DUP_VAL_ON_INDEX: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

INVALID_CURSOR: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

INVALID_NUMBER: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

INVALID_PATH: 13.9. Handling File Errors with PLVfile, Advanced Oracle PL/SQL Programming with Packages

LOGIN_DENIED: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

NOT_LOGGED_ON: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

NO_DATA_FOUND

21.2.5. Using PLVtrc, Advanced Oracle PL/SQL Programming with Packages
8.3.1. Named System Exceptions , Oracle PL/SQL Programming
8.8. NO_DATA_FOUND: Multipurpose Exception, Oracle PL/SQL Programming

NO_SUCH_TABLE: 22.1.2. Package-Based Exceptions, Advanced Oracle PL/SQL Programming with Packages

PLVmsg with: 9.5. Integrating PLVmsg with Error Handling, Advanced Oracle PL/SQL Programming with Packages

PROGRAM_ERROR: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

ROWTYPE_MISMATCH: 6.12.5.2. Handling the ROWTYPE_MISMATCH exception, Oracle PL/SQL Programming

SNAPSHOT_TOO_OLD: 22.1.2. Package-Based Exceptions, Advanced Oracle PL/SQL Programming with Packages

SQLCODE function: 13.3.5. The SQLCODE function, Oracle PL/SQL Programming

STORAGE_ERROR: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

TIMEOUT_ON_RESOURCE: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

TOO_MANY_ROWS: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

TRANSACTION_BACKED_OUT: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

UTL_FILE package: 13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages

VALUE_ERROR

A.1.3. Exception Handling, Advanced Oracle PL/SQL Programming with Packages
A.2.3. Exception Handling, Advanced Oracle PL/SQL Programming with Packages
13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages
8.3.1. Named System Exceptions , Oracle PL/SQL Programming

ZERO_DIVIDE: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

aliasing: 1.3.4.5. Same exception, different causes, Oracle Built-in Packages

as package: 16.3.1.1. A package of exceptions, Oracle PL/SQL Programming

assertion_failure: 5.3.5. Assertion routines, Advanced Oracle PL/SQL Programming with Packages

continuing once handled: 8.6.4. Continuing Past Exceptions, Oracle PL/SQL Programming

declaring in packages: 16.3. The Package Specification, Oracle PL/SQL Programming

exception section of code: 8.2. The Exception Section, Oracle PL/SQL Programming

file: 13.9. Handling File Errors with PLVfile, Advanced Oracle PL/SQL Programming with Packages

for branching logic: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

formatting handlers of: 3.3.3. Formatting Exception Handlers, Oracle PL/SQL Programming

handler development: 1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming

handles for: 8.6. Handling Exceptions, Oracle PL/SQL Programming

handling: 22.2.3. Avoid Exception Handlers for Normal Program Exits, Oracle PL/SQL Programming

like IF statement: 8.9. Exception Handler as IF Statement, Oracle PL/SQL Programming

multiple: 8.6.1. Combining Multiple Exceptions in a Single Handler, Oracle PL/SQL Programming

structure for: 8.4. Determining Exception-Handling Behavior, Oracle PL/SQL Programming

tips for: 8.10. RAISE Nothing but Exceptions, Oracle PL/SQL Programming

handling in built-in packages: 1.3.4. Exception Handling and Built-in Packages, Oracle Built-in Packages

Oracle Developer/2000 and: 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1, Oracle Built-in Packages

identifying cause of: 1.3.4.5. Same exception, different causes, Oracle Built-in Packages

insert failure: 5.15.1. Package constants and exceptions, Advanced Oracle PL/SQL Programming with Packages

list_full: 5.18.1. Package exceptions, Advanced Oracle PL/SQL Programming with Packages

list_undefined: 5.18.1. Package exceptions, Advanced Oracle PL/SQL Programming with Packages

messages: (see messages)

nullifying effect of raised: 5.2.2.2. Nullifying the effect of a raised exception, Oracle PL/SQL Programming

out_of_bounds: 5.18.1. Package exceptions, Advanced Oracle PL/SQL Programming with Packages

overlapping names of: 8.4.1.3. Overlapping exception names, Oracle PL/SQL Programming

package exception section: 1.6.3.2. The exception section, Advanced Oracle PL/SQL Programming with Packages

process halted: 22.1.10. Bailing Out with PLVexc, Advanced Oracle PL/SQL Programming with Packages

programmer-defined

8.3.2. Named Programmer-Defined Exceptions, Oracle PL/SQL Programming
8.3.4. Unnamed Programmer-Defined Exceptions , Oracle PL/SQL Programming

propagation of: 8.4.2. Propagation of an Exception , Oracle PL/SQL Programming

raised within handler: 8.5.4. Exceptions Raised in an Exception Handler, Oracle PL/SQL Programming

raising

8.5. Raising an Exception, Oracle PL/SQL Programming
8.10. RAISE Nothing but Exceptions, Oracle PL/SQL Programming

recording

22.1.7. Recording Errors, Advanced Oracle PL/SQL Programming with Packages
22.3.3.3. Recording the exception, Advanced Oracle PL/SQL Programming with Packages

resulting action options: 22.1.4. Exception Handling Actions, Advanced Oracle PL/SQL Programming with Packages

scope of: 8.4.1. Scope of an Exception, Oracle PL/SQL Programming

system: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

trapping invalid arguments: 22.2.4.1. Trap invalid argument values, Oracle PL/SQL Programming

types of: 8.3. Types of Exceptions, Oracle PL/SQL Programming

exclusive or (see XOR bit operation)

execImmed program, ndsutil.pkg file: 4.7. NDS Utility Package, Guide to Oracle8i Features

execsql procedure

5.9.2. Controlling execution of dynamic SQL, Advanced Oracle PL/SQL Programming with Packages
19.5.8. Controlling Execution of Dynamic SQL, Advanced Oracle PL/SQL Programming with Packages

executable section, PL/SQL: 6.1. Structured Programming in PL/SQL , Oracle Web Applications

execute authority

1.3.5. Guaranteeing Transaction Integrity, Advanced Oracle PL/SQL Programming with Packages
4.3.6. Granting Access to PL/Vision, Advanced Oracle PL/SQL Programming with Packages
1.3.2. Improved Execution Authority and Transaction Integrity with PL/SQL, Oracle PL/SQL Programming
23.2. Transaction Integrity and Execute Authority, Oracle PL/SQL Programming
collections and: 19.8.1. Privileges, Oracle PL/SQL Programming
on stored objects: 23.2.1. Execute Authority on Stored Objects, Oracle PL/SQL Programming
packages and: 23.2.1. Execute Authority on Stored Objects, Oracle PL/SQL Programming
sharing code and: 23.1.4. Key Concepts for Program Execution, Oracle PL/SQL Programming

execute procedure

5.9.3. Bundled, low-level operations, Advanced Oracle PL/SQL Programming with Packages
19.5.6.4. Passthrough elements, Advanced Oracle PL/SQL Programming with Packages

execute_and_close procedure

5.9.3. Bundled, low-level operations, Advanced Oracle PL/SQL Programming with Packages
19.5.6.2. Execute and close, Advanced Oracle PL/SQL Programming with Packages

execute_and_fetch procedure

5.9.3. Bundled, low-level operations, Advanced Oracle PL/SQL Programming with Packages
19.5.6.4. Passthrough elements, Advanced Oracle PL/SQL Programming with Packages

executing function: 5.9.2. Controlling execution of dynamic SQL, Advanced Oracle PL/SQL Programming with Packages

execution, shared code: 23.1. Executing Stored Code, Oracle PL/SQL Programming

execution privileges, DDL: 19.4.1. DDL Operations , Advanced Oracle PL/SQL Programming with Packages

execution status, registering: 7. Defining an Application Profile, Oracle Built-in Packages

execution time: (see performance)

existence checking, files: 5.11.6. Checking for file existence, Advanced Oracle PL/SQL Programming with Packages

exiting loops: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

expiration time: 5.3.6. Message Properties Record Type, Oracle Built-in Packages

explicit

conversion functions: 14. Conversion Functions, Oracle PL/SQL Programming

cursors

(see also cursors)
1.7.4. Standardize Your PL/SQL Development Environment, Oracle PL/SQL Programming
6.2.1. Types of Cursors, Oracle PL/SQL Programming
6.3.3. Explicit Cursors, Oracle PL/SQL Programming
fetching from: 9.5.3. FETCH INTO from an Explicit Cursor, Oracle PL/SQL Programming

datatype conversion: 4.2.8.1. Explicit data conversions, Oracle PL/SQL Programming

exponents: 13.1.14. The POWER function, Oracle PL/SQL Programming

export/inport: (see master sites, instantiation)

extended ROWIDs

Oracle versions and: 9. Datatype Packages, Oracle Built-in Packages
converting to restricted ROWIDs: 9.1.3.9. The DBMS_ROWID.ROWID_TO_RESTRICTED function, Oracle Built-in Packages
creating from restricted ROWIDs: 9.1.3.8. The DBMS_ROWID.ROWID_TO_EXTENDED function, Oracle Built-in Packages
format: 9.1.2. ROWID Concepts, Oracle Built-in Packages

extending file I/O capabilities: 9.9.1. Extending File I/O Capabilities, Guide to Oracle8i Features

extension encapsulation: 1.3.5. Encapsulating Access to the Built-in Packages, Oracle Built-in Packages

extensions

file: 2.4. Organizing Package Source Code, Advanced Oracle PL/SQL Programming with Packages
filename: (see filenames)
package element names: 2.3.3. Avoiding Superfluous Naming Elements, Advanced Oracle PL/SQL Programming with Packages

external LOBs

1.4.7.6. Large object support, Oracle PL/SQL Programming
8.2.1.1. Internal and external LOBs, Oracle Built-in Packages
8.2.1.6. The LOB locator, Oracle Built-in Packages

external procedures

external datatypes: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming

external procedures: 21. External Procedures, Oracle PL/SQL Programming

OCI routines for: 21.5. OCI Service Routines, Oracle PL/SQL Programming
architecture of: 21.1.2. Architecture, Oracle PL/SQL Programming
creating: 21.2. Steps in Creating an External Procedure, Oracle PL/SQL Programming
data dictionary entries: 21.6.1. Data Dictionary, Oracle PL/SQL Programming
debugging: 21.6.2. Rules and Warnings About External Procedures, Oracle PL/SQL Programming
examples: 21.7. Examples, Oracle PL/SQL Programming
listeners for: 21.2.1. Step 1: Set Up the Listener, Oracle PL/SQL Programming
mapping parameters: 21.4. Mapping Parameters, Oracle PL/SQL Programming
syntax: 21.3. Syntax for External Procedures, Oracle PL/SQL Programming
warnings about: 21.6.2. Rules and Warnings About External Procedures, Oracle PL/SQL Programming

external programs: 1.1. The Power of Built-in Packages, Oracle Built-in Packages

DBMS_PIPE used to execute: 3.1.7.1. Communicating with the outside world, Oracle Built-in Packages

external references: 3.1. A Look at the Definer Rights Model, Guide to Oracle8i Features

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