start page | rating of books | rating of authors | reviews | copyrights

CD Home

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

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.