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

Index: P

p package (PL/Vision)

6.1.6.1. Encapsulating DBMS_OUTPUT

About PL/Vision

pack_from_tbl procedure : 3.1.7.3. The dbpipe utility package

PACK_MESSAGE procedure

3.1.1.1. DBMS_PIPE programs

3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure

sending/receiving relationship and : 3.1.7.3. The dbpipe utility package

PACK_MESSAGE_RAW procedure

3.1.1.1. DBMS_PIPE programs

3.1.4.2. The DBMS_PIPE.PACK_MESSAGE_RAW procedure

PACK_MESSAGE_ROWID procedure

3.1.1.1. DBMS_PIPE programs

3.1.4.3. The DBMS_PIPE.PACK_MESSAGE_ROWID procedure

pack_send_friend procedure

3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure

3.1.6.1. Defining message types and encapsulating communications logic

pack_send_request procedure

3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure

3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function

3.1.7.5. The pipesvr package

pack_send_status procedure : 3.1.7.5. The pipesvr package

package body, definition : 1.3.1. What Is a Package?

package names, returning : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

package specification, definition : 1.3.1. What Is a Package?

package-defined exceptions

1.3.4. Exception Handling and Built-in Packages

1.3.4.2. Package-defined exception

package-named system exceptions

1.3.4. Exception Handling and Built-in Packages

1.3.4.1. Package-named system exception

package-specific exceptions

1.3.4. Exception Handling and Built-in Packages

1.3.4.4. Package-specific exception

Oracle Developer/2000 and : 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1

packages

(see also built-in packages)

1.3.1. What Is a Package?

controlling use of elements : 1.3.2. Controlling Access with Packages

description : 1.3.1. What Is a Package?

dot notation for referencing elements : 1.3.3. Referencing Built-in Package Elements

exception handling, identifying cause of : 1.3.4.5. Same exception, different causes

pinning : (see shared pool)

recompiling : 10.3.2. Compiling PL/SQL Objects

referencing elements of : 1.3.3. Referencing Built-in Package Elements

refresh state : 14.1.2.1. The DBMS_SNAPSHOT.I_AM_A_REFRESH function

replicated packages : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure

resetting state : 11.1.4.3. The DBMS_SESSION.RESET_PACKAGE procedure

parallel server mode, testing for : 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function

parameters

(see also initialization parameters)

10.1.2.13. The DBMS_UTILITY.GET_PARAMETER_VALUE function

ANY parameters : 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4)

describing : 10.2. DBMS_DESCRIBE: Describing PL/SQL Program Headers

optional : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure

parse procedure : 2.4.6. Problem-Solving Dynamic SQL Errors

PARSE procedure

2.2.3. DBMS_SQL Programs

2.3.3.1. The DBMS_SQL.PARSE procedure

encapsulating for error handling : 2.4.6. Problem-Solving Dynamic SQL Errors

SQL language version : 2.2.6. DBMS_SQL Nonprogram Elements

parse_long_one procedure : 2.3.3.2. Parsing very long SQL statements

parsing SQL statements : (see deferred parsing; SQL statements, parsing)

parslong.sp : 2.3.3.2. Parsing very long SQL statements

partitioned objects, analyzing : 10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only)

path function : 6.2.6.4. Adding support for paths

pathnames, UTL_FILE enhancement : 6.2.6.4. Adding support for paths

payload : (see messages (AQ); queues)

payload types : 5.3.3. Queue Type Names

pcex1.sql : 12.1.2.1. The DBMS_SPACE.FREE_BLOCKS procedure

peek procedure : 3.1.7.3. The dbpipe utility package

peers : (see master sites)

percent (multiple-character substitution) : 5.7.5.1. Wildcarded correlation identifiers

performance

array fetching and : 2.5.6.4. Using array processing to fetch

DBMS_SQL used for improving : 2.4.5. Improving the Performance of Dynamic SQL

session identifiers and : 11.1.5.4. The sid function

performance analysis

(see also statistics)

7. Defining an Application Profile

DBMS_APPLICATION_INFO used for

7. Defining an Application Profile

7.3. DBMS_APPLICATION_INFO Examples

7.3.7. Monitoring Application SQL Resource Consumption

7.3.8. Session Monitoring and Three-Tier Architectures

hashing (example) : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function

storing information for (example) : 7.3.3. The set_stats Procedure

pinning : (see shared pool)

pipe1 procedure : 3.1.7.2. Exploring DBMS_PIPE

pipe1.sql : 3.1.7.2. Exploring DBMS_PIPE

pipe2.sql : 3.1.7.2. Exploring DBMS_PIPE

pipenames : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

pipes

(see also DBMS_PIPE package; message buffers; messages (pipes))

3.1. DBMS_PIPE: Communicating Between Sessions

advanced queuing versus : 3.1.2.3. Pipe communications logic

creating

3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

3.1.3.4. The DBMS_PIPE.PURGE procedure

3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function

RECEIVE_MESSAGE and : 3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function

SEND_MESSAGE and : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

encapsulating pack/send and receive/unpack : 3.1.7.5. The pipesvr package

implementation of : 3.1.2. How Database Pipes Work

job queue and : 13. Job Scheduling in the Database

memory for

allocating : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

freeing

3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function

3.1.3.4. The DBMS_PIPE.PURGE procedure

tips about : 3.1.6.6. Sizing and removing pipes for good memory management

names for : 3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

packing/unpacking relationship : 3.1.7.2. Exploring DBMS_PIPE

purging : 3.1.3.4. The DBMS_PIPE.PURGE procedure

removing : 3.1.3.2. The DBMS_PIPE.REMOVE_PIPE function

separating messages for specific recipients : 3.1.6.2. Separating messages

timeouts

3.1.5.1. The DBMS_PIPE.SEND_MESSAGE function

3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function

3.1.6.4. Paying attention to timeouts

unique session names, returning : 3.1.3.5. The DBMS_PIPE.UNIQUE_SESSION_NAME function

utility package : 3.1.7.3. The dbpipe utility package

pipesvr package

(see also specific program names)

3.1.7.5. The pipesvr package

pipesvr.sql

3.1.3.3. The DBMS_PIPE.RESET_BUFFER procedure

3.1.5.2. The DBMS_PIPE.RECEIVE_MESSAGE function

3.1.7.5. The pipesvr package

pipex1.sql

3.1.4.1. The DBMS_PIPE.PACK_MESSAGE procedure

3.1.6.1. Defining message types and encapsulating communications logic

pipex2.sql : 3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function

pl procedure : 6.1.6.1. Encapsulating DBMS_OUTPUT

PL/SQL

scope with dynamic SQL : 2.4.8. Executing Dynamic PL/SQL

blocks, syntax for : 2.4.8. Executing Dynamic PL/SQL

connections and : 2.4.7. Executing DDL in PL/SQL

debugging stored code : 6.1. DBMS_OUTPUT: Displaying Output

dynamic execution of : 2. Executing Dynamic SQL and PL/SQL

tables : (see index-by tables)

PL/SQL server, DBMS_PIPE implementation of : 3.1.7.4. Implementing a server program

PL/Vision (RevealNet product) : About PL/Vision

PL/Vision Lite : 2.4.6. Problem-Solving Dynamic SQL Errors

place_bid procedure : 3.2.3.5. The auction package

placeholders : (see host variables)

plsqlarray.sp : 2.5.6.5. Using array processing in dynamic PL/SQL

PLVdyn : About PL/Vision

PLVfile : About PL/Vision

pop procedure : 5.7.3. Building a Stack with AQ Using Sequence Deviation

PORT_STRING function

10.1.1. Getting Started with DBMS_UTILITY

10.1.2.19. The DBMS_UTILITY.PORT_STRING function

pragmas, packaged programs and : 1.3.7. Accessing Built-in Packaged Technology from Within SQL

priority groups

(see also site priority groups)

16.3. Priority Groups with DBMS_REPCAT

16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure

adding priority levels : 16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure

altering data values : 16.3.3.3. The DBMS_REPCAT.ALTER_PRIORITY_<datatype> procedure

altering priority levels : 16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure

comments, creating or changing : 16.3.2.3. The DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP procedure

concepts

16.3.1. About Priority Groups

16.3.3. Creating and Maintaining Priorities Within a Priority Group

creating : 16.3.2.1. The DBMS_REPCAT.DEFINE_PRIORITY_GROUP procedure

dropping priority groups : 16.3.2.2. The DBMS_REPCAT.DROP_PRIORITY_GROUP procedure

dropping priority levels by data value : 16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure

dropping priority levels by priority level number : 16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure

priority levels

adding : 16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure

altering : 16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure

dropping by data value : 16.3.4.2. The DBMS_REPCAT.DROP_PRIORITY_<datatype> procedure

dropping by level number : 16.3.4.1. The DBMS_REPCAT.DROP_PRIORITY procedure

dropping site priorities via : 16.4.3.2. The DBMS_REPCAT.DROP_SITE_PRIORITY_SITE procedure

priority package

(see also specific program names)

5.7.2. Working with Prioritized Queues

priority.spp : 5.7.2. Working with Prioritized Queues

priority.tst : 5.7.2. Working with Prioritized Queues

priority_name function : 5.7.2. Working with Prioritized Queues

private pipes

3.1. DBMS_PIPE: Communicating Between Sessions

3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

privileges

(see also roles)

2.2.1. Creating the DBMS_SQL Package

DDL statement execution and : 2.4.7. Executing DDL in PL/SQL

procedures

describing : 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure

recompiling : 10.3.2. Compiling PL/SQL Objects

referencing in packages : 1.3.3. Referencing Built-in Package Elements

replicated procedures : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure

process_request procedure : 3.1.7.5. The pipesvr package

producers

(see also consumers)

5.1.5. A Glossary of Terms

delaying dequeuing : 5.3.6. Message Properties Record Type

program names

finding within packages and DBMS_DESCRIBE : 10.2.3.2. Using psdesc.args as a quality assurance tool

registering : 7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure

returning

7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure

10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

syntax for : 10.2.2.1. Specifying a program name

programs

(see also functions; procedures)

1.3.3. Referencing Built-in Package Elements

describing : 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure

recompiling : 10.3.2. Compiling PL/SQL Objects

referencing in packages : 1.3.3. Referencing Built-in Package Elements

propagating messages

AQ features for : 5.1.4. Propagation Features

Oracle8 versions and : 5.2.2.3. Setting Oracle AQ compatibility

scheduling : 5.5.5.1. The DBMS_AQADM.SCHEDULE_PROPAGATION procedure

starting : 5.2.2.2. Starting propagation processes

unscheduling : 5.5.5.2. The DBMS_AQADM.UNSCHEDULE_PROPAGATION procedure

viewing schedules : 5.6.2.3. The DBA_JOBS view

propagating transactions

(see also deferred traansactions)

17.2.5. Propagating Deferred RPCs

disabling : 17.2.6.1. The DBMS_DEFER_SYS.EXCLUDE_PUSH function (Oracle8 only)

enabling and disabling : 17.2.4.5. The DBMS_DEFER_SYS.SET_DISABLED procedure

new destinations : 17.2.3. Copying Deferred Transactions to New Destinations

Oracle8 scheduling : 17.2.6. Scheduling Propagation (Oracle8 only)

purging : 17.2.6.2. The DBMS_DEFER_SYS.PURGE function (Oracle8 only)

pushing queued transactions

17.2.5. Propagating Deferred RPCs

17.2.6.3. The DBMS_DEFER_SYS.PUSH function

registering propagators : 17.2.6.8. The DBMS_DEFER_SYS.REGISTER_PROPAGATOR procedure (Oracle8 only)

scheduling purge : 17.2.6.4. The DBMS_DEFER_SYS.SCHEDULE_PURGE procedure (Oracle8 only)

scheduling push : 17.2.6.5. The DBMS_DEFER_SYS.SCHEDULE_PUSH procedure (Oracle8 only)

scheduling, strategies for : 17.2.5.1. Scheduling strategies

unregistrating propagators : 17.2.6.9. The DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR procedure (Oracle8 only)

unscheduling purge : 17.2.6.6. The DBMS_DEFER_SYS.UNSCHEDULE_PURGE procedure (Oracle8 only)

unscheduling push : 17.2.6.7. The DBMS_DEFER_SYS.UNSCHEDULE_PUSH procedure (Oracle8 only)

propagator accounts : 15.1.3. Granting and Revoking Propagator Accounts (Oracle8)

protocols (for messages)

5.1.5. A Glossary of Terms

5.3.4. Agents Object Type

tips about : 3.1.6.3. Establishing messaging protocols

prt package

(see also specific program names)

6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator

prt.spp : 6.1.6.2. Package specification for a DBMS_OUTPUT encapsulator

prvtjob.plb script : 13.3.3. DBMS_IJOB: Managing Other Users' Jobs

prvtoctk.plb script : 10.4.1. Getting Started with DBMS_RANDOM

prvtofln.plb script

14.3.1. Getting Started with DBMS_OFFLINE_SNAPSHOT

15.4.1. Getting Started with DBMS_OFFLINE_OG

prvtpool.plb script : 12.2.1. Getting Started with DBMS_SHARED_POOL

prvtrctf.sql script

15.5.1. Getting Started with DBMS_RECTIFIER_DIFF

17.2.1. Getting Started with DBMS_DEFER_SYS

17.4.1. Getting Started with DBMS_DEFER_QUERY

prvtrepc.sql script

15.1.1. Getting Started with DBMS_REPCAT_AUTH

15.2.1. Getting Started with DBMS_REPCAT_ADMIN

prvtutil.plb script : 11.2.1. Getting Started with DBMS_SYSTEM

psdesc package

(see also specific program names)

1.3.5.1. Examples of encapsulation packages

10.2.3.1. Features of the psdesc package

psdesc.spp : 10.2.3.1. Features of the psdesc package

psdesc.tst

10.2.2.2. The DESCRIBE level

10.2.2. Explaining DBMS_DESCRIBE Results

pseudocolumns : 9.1.2. ROWID Concepts

public pipes

3.1. DBMS_PIPE: Communicating Between Sessions

3.1.3.1. The DBMS_PIPE.CREATE_PIPE function

PURGE procedure (DBMS_DEFER_SYS)

17.2.1.1. DBMS_DEFER_SYS programs

17.2.6.2. The DBMS_DEFER_SYS.PURGE function (Oracle8 only)

PURGE procedure (DBMS_PIPE)

3.1.1.1. DBMS_PIPE programs

3.1.3.4. The DBMS_PIPE.PURGE procedure

purge_all_pipes procedure : 3.1.3.4. The DBMS_PIPE.PURGE procedure

PURGE_LOG procedure

14.1.1. Getting Started with DBMS_SNAPSHOT

14.1.4. Purging the Snapshot Log

PURGE_LOST_DB_ENTRY procedure

4.2.1.1. DBMS_TRANSACTION programs

4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure

PURGE_MASTER_LOG procedure

15.3.1.1. DBMS_REPCAT programs

15.3.6.3. The DBMS_REPCAT.PURGE_MASTER_LOG procedure

PURGE_MIXED procedure

4.2.1.1. DBMS_TRANSACTION programs

4.2.6.1. The DBMS_TRANSACTION.PURGE_MIXED procedure

PURGE_STATISTICS procedure

16.1.1. DBMS_REPCAT Programs

16.6.1.3. The DBMS_REPCAT.PURGE_STATISTICS procedure

purity levels : 1.3.7.1. Calling a packaged function in SQL

PUSH function

17.2.1.1. DBMS_DEFER_SYS programs

17.2.6.3. The DBMS_DEFER_SYS.PUSH function

push procedure : 5.7.3. Building a Stack with AQ Using Sequence Deviation

PUT procedure (DBMS_OUTPUT)

6.1.1.1. DBMS_OUTPUT programs

6.1.3.1. The DBMS_OUTPUT.PUT procedure

PUT procedure (UTL_FILE)

6.2.1.1. UTL_FILE programs

6.2.4.1. The UTL_FILE.PUT procedure

PUT_LINE procedure (DBMS_OUTPUT)

6.1.1.1. DBMS_OUTPUT programs

6.1.3.2. The DBMS_OUTPUT.PUT_LINE procedure

PUT_LINE procedure (UTL_FILE)

6.2.1.1. UTL_FILE programs

6.2.4.3. The UTL_FILE.PUT_LINE procedure

PUTF procedure (UTL_FILE)

6.2.1.1. UTL_FILE programs

6.2.4.4. The UTL_FILE.PUTF procedure

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