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.