Index Symbols | A | B | C | D | E | F | G | H | I | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z Index: C c_after constant : 5.13.1. Package constants c_all constant : 5.21.1. Package constants c_all_tokens constant : 5.22.1. Package constants c_append constant : 5.11.1. Package constants and exceptions c_before constant : 5.13.1. Package constants c_bi_tokens constant : 5.22.1. Package constants c_both constant : 5.13.1. Package constants c_datemask constant 5.3.1. PL/Vision constants 6.2. Setting the PL/Vision Date Mask c_def_length constant : 5.13.1. Package constants c_default constant : 21.1.5.3. Types of rollback activity c_delim constant 5.21.1. Package constants 21.1.4. Managing a PL/SQL Table Log c_dosdelim constant 5.11.1. Package constants and exceptions 13.2.1. Setting the Operating System Delimiter c_examples constant : 5.14.1. Package constants c_go constant 5.10.1. Package constants 22.1.4. Exception Handling Actions c_ignore_case constant : 5.21.1. Package constants c_incr_indent constant : 5.13.1. Package constants c_indent constant : 5.13.1. Package constants c_int_no_change constant : 5.12.1. Package Constants c_kw_tokens constant : 5.22.1. Package constants c_last constant : 21.1.5.3. Types of rollback activity c_last_pos constant : 5.28.1. Package constants c_leph constant 5.20.6. Programmatic cursor FOR loop elements 11.7. A Programmatic Cursor FOR Loop 11.7.2. Constructing the Execution String c_literal constant : 5.13.1. Package constants c_main constant : 5.14.1. Package constants c_modname constant 5.20.6. Programmatic cursor FOR loop elements 11.7. A Programmatic Cursor FOR Loop c_modspec constant 5.20.6. Programmatic cursor FOR loop elements 11.7. A Programmatic Cursor FOR Loop c_no_change constant : 5.12.1. Package Constants c_noaction constant : 21.1.5.3. Types of rollback activity c_none constant 5.13.1. Package constants 21.1.5.3. Types of rollback activity c_nonkw_tokens constant : 5.22.1. Package constants c_nousecor constant : 5.4.1. Package constants c_PLVlogsp constant : 21.1.5.3. Types of rollback activity c_prefix constant 5.2.3. Setting the line prefix 5.12.1. Package Constants 7.3. The Output Prefix c_read constant : 5.11.1. Package constants and exceptions c_recNgo constant 5.10.1. Package constants 22.1.4. Exception Handling Actions c_recNstop constant 5.10.1. Package constants 22.1.4. Exception Handling Actions c_respect_case constant : 5.21.1. Package constants c_show_object constant 5.20.6. Programmatic cursor FOR loop elements 11.7. A Programmatic Cursor FOR Loop 11.7.2. Constructing the Execution String c_stop constant 5.10.1. Package constants 22.1.4. Exception Handling Actions c_suffix constant : 5.12.1. Package Constants c_top_pos constant 5.28.1. Package constants 21.2.4.7. Retrieving stack contents c_unixdelim constant 5.11.1. Package constants and exceptions 13.2.1. Setting the Operating System Delimiter c_usecor constant : 5.4.1. Package constants c_word constant : 5.21.1. Package constants c_write constant : 5.11.1. Package constants and exceptions calc_totals procedure : 22.1.6.5. Integrating PLVexc with PLVtrc calibrate procedure : 5.27.6. Calibration and timing scripts calltype function : 6.3.1. Using the assert Procedure capitalization 2.2. Using Effective Coding Style for Packages 15.4.1. How to Find Source Code 18.1. PLVcase: Converting the Case of PL/SQL Programs case sensitivity : 2.5.2. Making Your Programs Case-Insensitive capture procedure 5.27.4. Capturing the current timestamp 14.2. Capturing the Start Time case sensitivity : 2.5.2. Making Your Programs Case-Insensitive cataloging code : 18.2. PLVcat: Cataloguing PL/SQL Source Code cfloop procedure 5.13.10. Miscellaneous code generators 16.2.8. Generating a Cursor FOR Loop char_name function : 5.6.3. Other functions and procedures characters line separator : 7.2. The Line Separator string :5.6. PLVchr: Operations on Single Characters (see also strings) checking existence Record Found? function : 16.2.7. Generating a "Record Found?" Function of files : 13.3. Creating and Checking Existence of Files last PLVobj cursor record : 11.4.3. Checking for Last Record checking input : 3.8.1. When the num_in Argument Is 0 clear_bailouts procedure 5.10.7. Bailing out program execution 22.1.10.1. Managing the bailout error list clear_pstab procedure 5.17.6. Managing the log 21.1.4.1. Counting and clearing the PL/SQL table clearecs procedure 5.28.8. Accessing the PLVtrc execution call stack (ECS) 21.2.4.5. Emptying the stack clearing : (see deleting) client-side packages : 1.2.2. The Client-Side Layers close_objects procedure 5.20.5. Interfacing with the PLVobj cursor 11.4.1. Opening and Closing the PLVobj Cursor closesrc procedure 5.15.4. Managing the source repository 12.9.1. Closing the Source closetrg procedure 5.15.6. Managing the target repository 12.9.2. Closing the Target closing files 13.4. Opening and Closing Files 21.1.3.2. Closing the file : 5.11.8. Closing a file PLVobj cursor : 11.4.1. Opening and Closing the PLVobj Cursor repository : 12.9.1. Closing the Source clrtrg procedure 5.15.6. Managing the target repository 12.9.3. Clearing the Target code (see also programming technique) 1.2.1. The Iceberg Approach to Coding author : 16.3.2. Setting the Code Author cataloging : 18.2. PLVcat: Cataloguing PL/SQL Source Code compiling : 15. PLVvu: Viewing Source Code and Compile Errors with PLVdyn package : 19.4.1.7. Compiling source code with PLVdyn consolidating : 2.9.2. Lava Lamp Code Consolidation converting case of : 18.1.2. A Script to Convert Programs converting to PL/SQL programs : 4.4.3. Converting Scripts to PL/SQL Programs created during installation : 4.6. Summary of Files on Disk customizing for users : 2.8.1.2. Fitting the program to the user debugging/testing : 22.1. The Challenge of Exception Handling development : 3. The PL/SQL Development Spiral displaying : 15.2.2. Setting the Code Overlap dynamic PL/SQL : 19.5.5. Executing Dynamic PL/SQL Code elapsed time of : 5.27. PLVtmr: Program Performance Analyzer execution time of : (see performance) finding source code : 15.4.1. How to Find Source Code for testing code : 4.6.2. Contents of the test Subdirectory generating 5.13. PLVgen: PL/SQL Code Generator 16. PLVgen: Generating PL/SQL Programs generation toggles : 2.6.2. Toggles for Code Generation halting execution of : 5.10.6. Exception handlers implementing windows : 2.7.3. Implementing the Window layers of : (see packages) line numbers : 16.3.8. Generating Line Numbers overloading programs : 2.8. Overloading for Smart Packages parallelization : 1.5.1.1. Leveraging builtin packages parsing 5.22. PLVprsps: PL/SQL Source Code Parsing 10.3.2. Parsing PL/SQL Code parsing program name : 11.3.2. Converting the Program Name pausing programs : 5.3.6. Miscellaneous programs pinning into memory : 1.4.3.1. Managing packages in shared memory PL/SQL repositories : 12. PLVio: Reading and Writing PL/SQL Source Code PLVtmr package with : 14.4. Using PLVtmr in Scripts redundant : (see redundancy) reusing (see flexibilty, code) 1.2.1. The Iceberg Approach to Coding 4.1.1. The Benefits of PL/Vision size restrictions : 1.6.4. Working with Large Packages standard header : 16.3.3. Using the Program Header stored : 5.29. PLVvu: Code and Error Viewing testing/debugging : 4.1.1. The Benefits of PL/Vision tracing : 16.3.4. Using the Program Trace upgrades and fixes : 1.6.1.6. Hide weaknesses to facilitate upgrades and fixes. code procedure 5.29.3. Displaying stored code 15.4.1. How to Find Source Code 17.2. Current Sources of Information code_after procedure 5.29.3. Displaying stored code 15.3.2. Displaying Code by Keyword 17.2. Current Sources of Information codependency, package : 2.4.1. Creating Codependent Packages columns, table : (see tables) comments 2.2. Using Effective Coding Style for Packages 5.13.5. Help generators 5.16.1. Analyzing PL/SQL string content 10.3.2.1. plsql_string procedure 17.4.3. Creating Help Text generating 16.2.5.1. Generating help text stubs 16.3.7. Generating Online Help Text Stubs retrieving : 17.5.3. Implementing Online Help commit processing : 20.1. PLVcmt: Enhancing Commit Processing incremental commits : 20.1.3. Performing Incremental Commits toggling : 20.1.4. Controlling Commit Processing commit_after procedure 5.7.4. Managing the commit counter 12.9.3. Clearing the Target 20.1.3.1. Setting the commit point commits : A.2.6. Builtin Packages committing function : 5.7.1. Controlling commit activity compatibility 3.3. Supplying Backward Compatibility 3.11. Don't Forget Backward Compatibility compile procedure 5.9.4. Data Definition Language operations 19.4.1.7. Compiling source code with PLVdyn compiling errors 15. PLVvu: Viewing Source Code and Compile Errors 5.29.4. Displaying compile errors compiling code 1.3.6. Performance Improvement with PLVdyn : 19.4.1.7. Compiling source code with PLVdyn conditional logic A.1.1. Conditional Logic A.2.1. Conditional Logic configuring PLVfk package : 19.6.2. Configuring the PLVfk Package CONNECT command : 7.1.2. Displaying Dates consolidation of code : 2.9.2. Lava Lamp Code Consolidation CONSTANT declaration : 1.6.1.4. Remove hard-coded literals from your application constants: (see literals) convert_type procedure 5.20.8. Miscellaneous PLVobj programs 11.3.2. Converting the Program Name converting PL/SQL table to database table : 21.1.4.3. Transferring a PL/SQL table log to a database table case : (see capitalization) program name : 11.3.2. Converting the Program Name scripts into PL/SQL : 4.4.3. Converting Scripts to PL/SQL Programs convobj procedure 5.20.8. Miscellaneous PLVobj programs 11.3.2. Converting the Program Name copying file contents : 13.7. Copying File Contents files : 5.11.11. Copying a file from source to target repository : 5.15.9. Miscellaneous PLVio programs object names into table : 11.6. Populating a PL/SQL Table with Object Names source to target repository : 12.7.2. Batch Transfer of Source to Target cor procedure : 19.4.1.7. Compiling source code with PLVdyn counter, commit : 5.7.4. Managing the commit counter counter, PLVcmt : (see PLVcmt package) cover packages : 1.6.4. Working with Large Packages CPU time : (see performance) CREATE OR REPLACE 17.5.2. Locating Text in the Data Dictionary : 19.4.1.7. Compiling source code with PLVdyn create-or-replace syntax : 16.3.9. Including CREATE OR REPLACE creating files : 13.3. Creating and Checking Existence of Files lists : 5.18.2. Creating and destroying lists messages : 9.2. Storing Message Text stacks : 5.24.2. Creating and destroying stacks creativity : 4.1.1. The Benefits of PL/Vision curdecl procedure 5.13.10. Miscellaneous code generators 16.2.6. Generating a Cursor Declaration curfail procedure : 5.27.6. Calibration and timing scripts currmod function 5.28.6. Tracing PL/SQL code execution 21.2.4.3. Current module currname function 5.20.4. Accessing the current object 11.3.1. Setting Individual Elements of Current Object currschema function 5.20.4. Accessing the current object 11.3.1. Setting Individual Elements of Current Object currtype function 5.20.4. Accessing the current object 11.3.1. Setting Individual Elements of Current Object cursors A.1.4. Cursors A.2.4. Cursors 1.3.4. Object Persistence 1.4.1. The Package Specification binding objects to : 11.5. Binding Objects to a Dynamic Cursor FOR loop 11.7. A Programmatic Cursor FOR Loop 16.2.8. Generating a Cursor FOR Loop generating declaration : 16.2.6. Generating a Cursor Declaration PLVobj : 5.20.5. Interfacing with the PLVobj cursor PLVobj package (obj_cur) 11.2.1. Cursor Into ALL_OBJECTS 11.4.1. Opening and Closing the PLVobj Cursor cursucc procedure : 5.27.6. Calibration and timing scripts customizing parsing delimiter : 10.1.2. Customizing the Delimiter Set customizing programs for users : 2.8.1.2. Fitting the program to the user Symbols | A | B | C | D | E | F | G | H | I | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z Copyright (c) 2000 O'Reilly & Associates. All rights reserved.