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: P

p package

2.8.1.1. Supporting many data combinations

4.2.1. Building Blocks

5.2. p: a DBMS_OUTPUT Substitute

7. p: A Powerful Substitute for DBMS_OUTPUT

l : (see l procedure)

output from : 7.4. Controlling Output from p

package libraries : 1.5.2. Prebuilt Packages

packages

(see also modularizing)

A.1.6. Builtin Packages

1.1. What Is a PL/SQL Package?

2.9. Modularizing for Maintainable Packages

5.13.6. Generating a package

access to elements : 1.4.4. Access to Package Elements

building : 1.6. Building Packages

built-in : A.2.6. Builtin Packages

codependency : 2.4.1. Creating Codependent Packages

effective coding of : 2. Best Practices for Packages

exception : (see PLVexc packages)

exception section : 1.6.3.2. The exception section

flexibility : 2.6. Building Flexibility Into Your Packages

generating : 16.2.1. Generating a Package

help : (see documentation)

hiding elements of

1.3.1. Enforced Information Hiding

2.7. Building Windows Into Your Packages

2.10. Hiding Package Data

in PL/Vision

4.2. PL/Vision Package Bundles

4.3.5. Creating the PL/Vision Packages

5. PL/Vision Package Specifications

initializing

1.6.3. The Initialization Section

1.6.5.2. Asserting the purity level of the initialization section

interface

2.5. Constructing the Optimal Interface to Your Package

2.10.3. Simplifying Package Interfaces

layering : 2.9. Modularizing for Maintainable Packages

memory architecture : 1.4.3. The Memory-Resident Architecture of Packages

memory requirements : 4.3.2. Storage Requirements

multiple, constructing : 2.11. Simultaneous Construction of Multiple Packages

naming : 2.3. Selecting Package Names

online help : (see PLVhlp package)

ordering elements of : 2.2.1. Choosing the Order of Elements

package body

1.6. Building Packages

1.6.2. The Package Body

package specification

1.4.1. The Package Specification

1.6. Building Packages

PL/SQL : 19.2. Declarative Programming in PL/SQL

PLVctlg table : 18.2.2.1. PLVctlg table

recompiling : 2.4. Organizing Package Source Code

referencing elements of : 1.4.2. Referencing Package Elements

synonyms for : 4.3.6. Granting Access to PL/Vision

windows in : 2.7. Building Windows Into Your Packages

working with large : 1.6.4. Working with Large Packages

page size

17.4.2. Setting the Page Size

17.5.6.4. Maintaining the current page variables

online help : 5.14.2. Setting the page size

pagesize function : 17.4.2. Setting the Page Size

paragraphs

5.21.2. Wrapping long strings into paragraphs

10.1.4. Wrapping Strings into Paragraphs

parallelization of programs : 1.5.1.1. Leveraging builtin packages

parameter list : 16.2.2.2. A procedure with parameter list and executable code

PARSE procedure : 19.5.6.1. Open and parse

parse tree : 1.6.4. Working with Large Packages

parse_delete procedure

5.9.3. Bundled, low-level operations

19.5.6.3. Parse for delete

parse_name procedure

5.11.13. Miscellaneous operations

13.2.3. Parsing the File Name

parsing

code : 5.22. PLVprsps: PL/SQL Source Code Parsing

delimiter, defining : 10.1.2. Customizing the Delimiter Set

file name : 13.2.3. Parsing the File Name

PL/SQL code : 10.3.2. Parsing PL/SQL Code

program names : 11.3.2. Converting the Program Name

strings

5.16. PLVlex: Lexical Analysis

5.21. PLVprs: String Parsing

10. PLVprs, PLVtkn, and PLVprsps: Parsing Strings

partial installation : 4.4.4. A Warning About Partial Installation

pauding programs : 5.3.6. Miscellaneous programs

pause procedure

5.3.6. Miscellaneous programs

6.4.4. Pausing Your Program

pausing help text (see more procedure)

pausing programs

6.4.4. Pausing Your Program

A.2.6. Builtin Packages

perform_commit procedure

5.7.3. Performing commits

20.1.2. The COMMIT Substitute

perform_rollback function

5.23.3. Performing rollbacks

20.2.4. Performing Rollbacks

performance

A.2.6. Builtin Packages

1.3.6. Performance Improvement

3.10. Choosing the Best Performer

5.27.6. Calibration and timing scripts

14. PLVtmr: Analyzing Program Performance

dynamic PL/SQL : 19.5.5.3. The overhead of dynamic PL/SQL

package size : 1.6.4. Working with Large Packages

permissions : (see access)

persistence

1.3.4. Object Persistence

1.6.1.3. Need global data structures for your PL/SQL programs

pinning code into memory : 1.4.3.1. Managing packages in shared memory

pkg procedure

5.13.6. Generating a package

16.2.1. Generating a Package

pky procedure : 5.8.3. Dumping the DDL

PL/SQL

call stack : 21.2.2. Accessing the PL/SQL Call Stack

code, parsing : 10.3.2. Parsing PL/SQL Code

declarative programming : 19.2. Declarative Programming in PL/SQL

dynamic code : 19.5.5. Executing Dynamic PL/SQL Code

objects : 11. PLVobj: A Packaged Interface to ALL_OBJECTS

performance and : 19.5.5.3. The overhead of dynamic PL/SQL

reserved words : 5.26. PLVtkn: Token Table Interface

source code repositories : 12. PLVio: Reading and Writing PL/SQL Source Code

tokens : (see reserved words)

PL/Vision : 4.1. What Is PL/Vision?

bindobj procedure in : 11.5.3. Using bindobj in PL/Vision

cataloging : 18.2.3.4. Cataloguing PL/Vision

enhancing PLVexc with : 22.3.4. Revamping the PLVexc Package

installing : 4.3. Installation Instructions

logging : (see logging)

loopexec procedure in : 11.7.4. Applying loopexec in PL/Vision

packages of

4.2. PL/Vision Package Bundles

4.3.5. Creating the PL/Vision Packages

5. PL/Vision Package Specifications

PLVgen and : 16.4.6. Leveraging PL/Vision in PLVgen

PLVmsg with : 9.5.1. Using PLVmsg in PL/Vision

sharing among users : 4.3.6. Granting Access to PL/Vision

tracing : (see tracing)

PL/Vision Lite : 4.2. PL/Vision Package Bundles

placeholder function : 5.9.7. Miscellaneous programs

plsql procedure

5.8.3. Dumping the DDL

5.9.6. Executing dynamic PL/SQL

19.5.5. Executing Dynamic PL/SQL Code

plsql_block function

5.9.7. Miscellaneous programs

19.5.5.1. Implementation of PLVdyn.plsql

plsql_delimiters constant

5.21.1. Package constants

10.1.2. Customizing the Delimiter Set

plsql_identifier variable

5.3.2. Anchoring datatypes

6.5. The Predefined Datatypes

19.5.5.2. Scope of a dynamic PL/SQL block

plsql_string procedure

5.22.3. Parsing PL/SQL source code

10.3.2.1. plsql_string procedure

plug-and-play packages

4.2.3. Plug-and-Play Components

19. PLVdyn and PLVfk: Dynamic SQL and PL/SQL

PLV package : 4.2.1. Building Blocks

constants and functions : 6. PLV: Top-Level Constants and Functions

PLV_token table : 10.2.1. Keeping Track of PL/SQL Keywords

PLVcase package

4.2.2. Developer Utilities

5.4. PLVcase: PL/SQL Code Conversion

18.1. PLVcase: Converting the Case of PL/SQL Programs

PLVcat package

4.2.2. Developer Utilities

5.5. PLVcat: PL/SQL Code Cataloguing

10.3.1. Selecting Token Types for Parsing

18.2. PLVcat: Cataloguing PL/SQL Source Code

references and dependencies : 18.2.4. Identifying References and Dependencies

plvcat.sql script : 18.2.3.4. Cataloguing PL/Vision

PLVchar package : 4.2.1. Building Blocks

PLVchr package : 5.6. PLVchr: Operations on Single Characters

PLVcmt package

4.2.3. Plug-and-Play Components

5.7. PLVcmt: Commit Processing

20.1. PLVcmt: Enhancing Commit Processing

21.1.2.1. Using put_line

PLVctlg table : 18.2.2. The PLVcat Database Tables

PLVddd package

4.2.2. Developer Utilities

5.8. PLVddd: DDL Syntax Dump

PLVdyn package

2.7. Building Windows Into Your Packages

4.2.3. Plug-and-Play Components

4.4.1. Special Handling for PLVdyn

5.9. PLVdyn: Dynamic SQL Operations

19.4. PLVdyn: A Code Layer over DBMS_SQL

compiling code with : 19.4.1.7. Compiling source code with PLVdyn

displaying table contents : 19.5.7. Displaying a Table

schemas and : 19.5.10. Executing PLVdyn in Different Schemas

PLVdyn1 package : 4.2.3. Plug-and-Play Components

PLVexc package

4.2.3. Plug-and-Play Components

5.10. PLVexc: Exception Handling

16.3.5. Using the PLVexc Exception Handler

19.1. About Plug-and-Play

21.1.2.1. Using put_line

22. Exception Handling

enhancing with PL/Vision : 22.3.4. Revamping the PLVexc Package

PLVlog package and : 22.3.4.1. Leveraging PLVLog

PLVmsg with : 9.5. Integrating PLVmsg with Error Handling

PLVtrc package and : 22.1.6.5. Integrating PLVexc with PLVtrc

PLVfile package

4.2.1. Building Blocks

5.11. PLVfile: Operating System I/O Manager

13. PLVfile: Reading and Writing Operating System Files

PLVfk package

4.2.3. Plug-and-Play Components

5.12. PLVfk: Foreign Key Interface

19.6. PLVfk: Generic Foreign Key Lookups

PLVgen package

2.2. Using Effective Coding Style for Packages

2.6.2. Toggles for Code Generation

4.2.2. Developer Utilities

5.13. PLVgen: PL/SQL Code Generator

16. PLVgen: Generating PL/SQL Programs

overloading in : 16.4.4. Overloading in PLVgen

plvgrant.sql script : 4.3.6. Granting Access to PL/Vision

PLVhlp : 4.2.2. Developer Utilities

PLVhlp package : 5.1. Common Package Elements

PLVhlp package

4.4. Installing Online Help for PL/Vision

4.5. Using Online Help

5.14. PLVhlp: Online Help Architechture

12.1. Why PLVio?

16.2.5.1. Generating help text stubs

17. PLVhlp: Online Help for PL/SQL Programs

plvins23.sql script : 4.3.5. Creating the PL/Vision Packages

plvinst.sql script : 4.3.5. Creating the PL/Vision Packages

PLVio package

4.2.1. Building Blocks

5.15. PLVio: Input/Output Processing

12. PLVio: Reading and Writing PL/SQL Source Code

PLVhlp package and : 17.5.5. Constructing an Online Help Package

PLVlex package

4.2.1. Building Blocks

5.16. PLVlex: Lexical Analysis

PLVlog package

2.6.3. Changing Package Behavior Without Changing the Application

4.2.3. Plug-and-Play Components

5.17. PLVlog: Logging Facility

21.1. PLVlog: Logging Activity in PL/SQL Programs

PLVexc package and

22.1.7.1. Logging errors

22.3.4.1. Leveraging PLVLog

rollbacks : 21.1.5. Rolling Back with PLVlog

PLVlst package

4.2.1. Building Blocks

5.18. PLVlst: List Manager

PLVmsg package

4.2.1. Building Blocks

5.19. PLVmsg: Message Handling

9. PLVmsg: Single-Sourcing PL/SQL Message Text

22.1.6.4. Defining error messages with PLVmsg

PLVobj package

4.2.1. Building Blocks

5.20. PLVobj: Object Interface

11. PLVobj: A Packaged Interface to ALL_OBJECTS

PLVprs package

4.2.1. Building Blocks

5.21. PLVprs: String Parsing

10.1. PLVprs: Useful String Parsing Extensions

PLVprsps : 4.2.1. Building Blocks

PLVprsps package : 10.3. PLVprsps: Parsing PL/SQL Strings

plvpsyn.sql script : 4.3.6. Granting Access to PL/Vision

PLVrb package

4.2.3. Plug-and-Play Components

5.23. PLVrb: Rollback Processing

20.2. PLVrb: Performing Rollbacks

PLVrfrnc table : 18.2.4.1. Examining the references

PLVstk package

4.2.1. Building Blocks

5.24. PLVstk: Stack Manager

PLVtab package

2.6. Building Flexibility Into Your Packages

2.8.1.1. Supporting many data combinations

4.2.1. Building Blocks

5.25. PLVtab: Table Interface

8. PLVtab: Easy Access to PL/SQL Tables

PLVtkn package

4.2.1. Building Blocks

5.26. PLVtkn: Token Table Interface

10.2. PLVtkn: Managing PL/SQL Tokens

PLVtmr package

4.2.2. Developer Utilities

5.27. PLVtmr: Program Performance Analyzer

14. PLVtmr: Analyzing Program Performance

16.2.9. Generating a Timer Script

18.2.3.3. Examining the catalogue

19.5.5.3. The overhead of dynamic PL/SQL

PLVtrc package

4.2.3. Plug-and-Play Components

5.28. PLVtrc: Trace Facility

16.3.4. Using the Program Trace

21.2. PLVtrc: Tracing Execution of PL/SQL Programs

PLVexc package and : 22.1.6.5. Integrating PLVexc with PLVtrc

PLVvu package

4.2.2. Developer Utilities

5.29. PLVvu: Code and Error Viewing

15. PLVvu: Viewing Source Code and Compile Errors

17.2. Current Sources of Information

pop procedure : 5.24.3. Modifying stack contents

post-insert savepoint : 21.1.5.7. Setting the post-insert savepoint

pragmas : 1.6.5.1. RESTRICT_REFERENCES pragma

EXCEPTION_INIT : 5.10.2. Package-based exceptions

prebuilt packages : 1.5.2. Prebuilt Packages

predefined exceptions : 22.1.3. Impact of Predefined Exceptions

prefix table row value : 8.5. Setting the Display Prefix

prefix function

5.2.3. Setting the line prefix

5.25.6. Setting the row prefix

prefixes to package element names : 2.3.3. Avoiding Superfluous Naming Elements

prependitem procedure : 5.18.3. Modifying list contents

prevmod function

5.28.6. Tracing PL/SQL code execution

21.2.4.4. Previous module

private PL/Vision package synonyms : 4.3.6. Granting Access to PL/Vision

private elements

1.4.4.1. Public and private data

2.7. Building Windows Into Your Packages

2.10. Hiding Package Data

declaring before public : 2.2.1. Choosing the Order of Elements

package elements

1.3.1. Enforced Information Hiding

1.4.4. Access to Package Elements

privileges, DDL execution : 19.4.1. DDL Operations

proc procedure

5.13.7. Generating a procedure

16.2.2. Generating a Procedure

16.4.2. Implementing the Procedure Generator

procedures : (see functions)

execute authority : 1.3.5. Guaranteeing Transaction Integrity

generating

16.2.2. Generating a Procedure

16.4.2. Implementing the Procedure Generator

help : 16.2.5.2. Generating a help procedure

process_halted exception

5.10.2. Package-based exceptions

22.1.10. Bailing Out with PLVexc

22.1.2. Package-Based Exceptions

productivity : 4.1.1. The Benefits of PL/Vision

programming technique

A. Appendix: PL/SQL Exercises

1.2.1. The Iceberg Approach to Coding

10.1.3.6. numinstr function

analyzing performance : (see performance)

avoiding hard-coded literals : 3.12. Obliterating the Literals

avoiding redundancy : (see redundancy)

backward compatibility

3.3. Supplying Backward Compatibility

3.11. Don't Forget Backward Compatibility

coding packages : 2. Best Practices for Packages

consistent error data : 22.2.1.1. Recording consistent error data

cover package : 1.6.4. Working with Large Packages

declarative programming : 19.2. Declarative Programming in PL/SQL

handling exceptions : 22.3.1. Analyzing the Need

handling fatal errors : 22.1.10. Bailing Out with PLVexc

hard-coded transaction processing : 20.1.1. Who Needs PLVcmt?

logging : (see logging)

modularizing : 2.9. Modularizing for Maintainable Packages

object-oriented design : 1.3.2. Object-Oriented Design

overloading : 2.8.1. When to Overload

simultaneous package construction : 2.11. Simultaneous Construction of Multiple Packages

testing/debugging : 2.6.3.1. The test/debug cycle in PL/SQL

toggles : 2.6.1. Toggling Package Behavior

top-down design : 1.3.3. Top-Down Design

user interface : 3.4. Improving the User Interface

using package initialization section : 1.6.3.1. When to use the initialization section

using packages : 1.6.1. When Should You Build a Package?

windows : 2.7. Building Windows Into Your Packages

programs : (see code)

ps2db procedure

5.17.6. Managing the log

21.1.4.3. Transferring a PL/SQL table log to a database table

ps_callstack function

5.28.5. Accessing the PL/SQL call stack

21.2.2. Accessing the PL/SQL Call Stack

ps_module function

5.28.5. Accessing the PL/SQL call stack

21.2.2. Accessing the PL/SQL Call Stack

psformat procedure : 4.1.2. The Origins of PL/Vision

pstab constant : 5.3.1. PL/Vision constants

pstab2file procedure

5.11.11. Copying a file

13.7.4. Copying PL/SQL Table to File

pstab_count function

5.17.6. Managing the log

21.1.4.1. Counting and clearing the PL/SQL table

public PL/Vision package synonyms : 4.3.6. Granting Access to PL/Vision

public data package elements : 1.4.4. Access to Package Elements

public elements

1.4.4.1. Public and private data

2.7. Building Windows Into Your Packages

2.10. Hiding Package Data

2.10.4. When to Make Data Public

anchored declarations : 2.10.5. Anchoring to Public Variables

declaring before private : 2.2.1. Choosing the Order of Elements

package elements

1.3.1. Enforced Information Hiding

1.4.1. The Package Specification

purity levels : 1.6.5.1. RESTRICT_REFERENCES pragma

push procedure : 5.24.3. Modifying stack contents

PUT_LINE package

(see also p package)

7. p: A Powerful Substitute for DBMS_OUTPUT

5.2. p: a DBMS_OUTPUT Substitute

put_line procedure

5.11.10. Writing to a file

5.15.7. Reading and writing lines

5.17.4. Writing to the log

12.7. Writing to the Target

13.6. Writing to a File

16.4.3. put_line Procedure

21.1.2. Writing to the Log

specifying rollbacks : 21.1.5.5. Specifying rollbacks when calling put_line

PUT_LINE procedure : 2.8.1.1. Supporting many data combinations

put_line repository : 12.7.3. Displaying the Target Repository

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.