Book HomeBook HomeSearch this book

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


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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference