start page | rating of books | rating of authors | reviews | copyrights
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.