PL/SQL Packages Supplied PL/SQL Packages -- Index

Advanced Queuing

administrative interface, 4-11

DBMS_AQADM package, 5-1

altering

propagation method, 37-16, 37-24

anonymous PL/SQL blocks

dynamic SQL and, 51-2

arrays

BIND_ARRAY procedure, 51-6

bulk DML using DBMS_SQL, 51-15

available()

as a function of UTL_TCP, 66-5

Calendar package, 1-13

catproc.sql script, 1-2

character sets

ANY_CS, 18-3

CLOB datatype

NCLOBs, 18-3

close_all_connections()

as a function of UTL_TCP, 66-14

close_connection()

as a function of UTL_TCP, 66-13

collections

table items, 51-15

columns

column groups

adding members to, 37-6

creating, 37-44, 37-68

dropping, 37-49

removing members from, 37-50

command(), command_replies()

functions of UTL_SMTP, 65-4

comparing

tables, 34-3

conflict resolution

additive method, 37-12

statistics, 37-25, 37-74

connection

as a function of UTL_TCP, 66-2

function of UTL_SMTP, 65-2

CREATE PACKAGE BODY command, 1-3

CREATE PACKAGE command, 1-3

creating

packages, 1-3

CRLF

as a function of UTL_TCP, 66-3

cursors

DBMS_SQL package, 51-4

data definition language

asynchronous, 37-63

supplying asynchronous, 37-63

Data Encryption Standard, 23-1

data()

function of UTL_SMTP, 65-8

database tables

creating for DBMS_TRACE, 53-3

datatypes

DBMS_DESCRIBE, 12-5

DESC_TAB, 51-30

NCLOB, 18-3

PL/SQL

numeric codes for, 12-9

ROWID, 45-1

DBA_REPCATLOG view

purging, 37-69

DBA_REPCOLUMN_GROUP view

updating, 37-26

DBA_REPGROUP view

updating, 37-28

DBA_REPOBJECT view

updating, 37-29

DBA_REPPRIORITY_GROUP view

updating, 37-27

DBA_REPRESOLUTION view

updating, 37-33

DBA_REPRESOLUTION_STATISTICS view

purging, 37-70

DBA_REPSITES view

updating, 37-31

DBMS_ALERT package, 2-1

DBMS_APPLICATION_INFO package, 3-2

DBMS_AQ package, 4-1

DBMS_AQADM package, 5-1

DBMS_BACKUP_RESTORE package, 6-1

DBMS_DDL package, 7-1

DBMS_DEBUG package, 8-1

DBMS_DEFER package, 9-1, 9-2

CALL procedure, 9-3

CHAR_ARG procedure, 9-5

COMMIT_WORK procedure, 9-4

datatype_ARG procedure, 9-5

DATE_ARG procedure, 9-5

NUMBER_ARG procedure, 9-5

RAW_ARG procedure, 9-5

ROWID_ARG procedure, 9-5

TRANSACTION procedure, 9-7

VARCHAR2_ARG procedure, 9-5

DBMS_DEFER_QUERY package, 10-1, 10-2

GET_ARG_FORM function, 10-3

GET_ARG_TYPE function, 10-4

GET_CALL_ARGS procedure, 10-6

GET_CHAR_ARG procedure, 10-7

GET_datatype_ARG function, 10-7

GET_NUMBER_ARG procedure, 10-7

GET_RAW_ARG procedure, 10-7

GET_ROWID_ARG procedure, 10-7

GET_VARCHAR2_ARG procedure, 10-7

DBMS_DEFER_SYS package, 11-1, 11-2

DBMS_DESCRIBE package, 12-1

DBMS_DISTRIBUTED_TRUST_ADMIN package, 13-1

DBMS_HS package, 14-1

DBMS_HS_PASSTHROUGH package, 15-1

DBMS_IOT package, 16-1

DBMS_JOB package, 17-1

and instance affinity, 17-12

DBMS_LOB package, 18-1

DBMS_LOCK package, 19-1

DBMS_LOGMNR package, 20-1

DBMS_LOGMNR_D package, 21-1

DBMS_MVIEW package, 22-1

DBMS_SNAPSHOT package, 22-1, 48-1

DBMS_OBFUSCATION_TOOLKIT package, 23-1

DBMS_OFFLINE_OG package, 24-1, 24-2

BEGIN_INSTANTIATION procedure, 24-3

BEGIN_LOAD procedure, 24-4

END_INSTANTIATION procedure, 24-5

END_LOAD procedure, 24-7

RESUME_SUBSET_OF_MASTERS procedure, 24-8

DBMS_OFFLINE_SNAPSHOT package, 25-1, 25-2

BEGIN_LOAD procedure, 25-3

END_LOAD procedure, 25-5

DBMS_OLAP package, 26-1

DBMS_ORACLE_TRACE_AGENT package, 27-1

DBMS_ORACLE_TRACE_USER package, 28-1

DBMS_OUTPUT package, 29-1

DBMS_PCLXUTIL package, 30-1

DBMS_PIPE package, 31-1

DBMS_PROFILER package, 32-1

DBMS_RANDOM package, 33-1

DBMS_RECTIFIER_DIFF package, 34-1, 34-2

DIFFERENCES procedure, 34-3

RECTIFY procedure, 34-6

DBMS_REFRESH package, 35-1, 35-2

ADD procedure, 35-3

CHANGE procedure, 35-4

DESTROY procedure, 35-6

MAKE procedure, 35-7

REFRESH procedure, 35-9

SUBTRACT procedure, 35-10

DBMS_REPAIR package, 36-1

DBMS_REPCAT package, 37-1, 37-2

ADD_DELETE_RESOLUTION procedure, 37-12

ADD_GROUPED_COLUMN procedure, 37-6

ADD_MASTER_DATABASE procedure, 37-7

ADD_PRIORITY_CHAR procedure, 37-9

ADD_PRIORITY_datatype procedure, 37-9

ADD_PRIORITY_DATE procedure, 37-9

ADD_PRIORITY_NUMBER procedure, 37-9

ADD_PRIORITY_VARCHAR2 procedure, 37-9

ADD_SITE_PRIORITY_SITE procedure, 37-10

ADD_UNIQUENESS_RESOLUTION procedure, 37-12

ADD_UPDATE_RESOLUTION procedure, 37-12

ALTER_MASTER_PROPAGATION procedure, 37-16

ALTER_MASTER_REPOBJECT procedure, 37-17

ALTER_PRIORITY procedure, 37-19

ALTER_PRIORITY_CHAR procedure, 37-20

ALTER_PRIORITY_datatype procedure, 37-20

ALTER_PRIORITY_DATE procedure, 37-20

ALTER_PRIORITY_NUMBER procedure, 37-20

ALTER_PRIORITY_RAW procedure, 37-20

ALTER_SITE_PRIORITY procedure, 37-22

ALTER_SITE_PRIORITY_SITE procedure, 37-23

ALTER_SNAPSHOT_PROPAGATION procedure, 37-24

CANCEL_STATISTICS procedure, 37-25

COMMENT_ON_COLUMN_GROUP procedure, 37-26

COMMENT_ON_DELETE_RESOLUTION procedure, 37-33

COMMENT_ON_PRIORITY_GROUP procedure, 37-27

COMMENT_ON_REPGROUP procedure, 37-28

COMMENT_ON_REPOBJECT procedure, 37-29

COMMENT_ON_REPSITES procedure, 37-31

COMMENT_ON_SITE_PRIORITY procedure, 37-27

COMMENT_ON_SNAPSHOT_REPSITES procedure, 37-32

COMMENT_ON_UNIQUE_RESOLUTION procedure, 37-33

COMMENT_ON_UPDATE_RESOLUTION procedure, 37-33

COMPARE_OLD_VALUES procedure, 37-35

CREATE_MASTER_REPGROUP procedure, 37-37

CREATE_MASTER_REPOBJECT procedure, 37-38

CREATE_SNAPSHOT_REPGROUP procedure, 37-41

CREATE_SNAPSHOT_REPOBJECT procedure, 37-42

DEFINE_COLUMN_GROUP procedure, 37-44

DEFINE_PRIORITY_GROUP procedure, 37-45

DEFINE_SITE_PRIORITY procedure, 37-47

DO_DEFERRED_REPCAT_ADMIN procedure, 37-48

DROP_COLUMN_GROUP procedure, 37-49

DROP_DELETE_RESOLUTION procedure, 37-61

DROP_GROUPED_COLUMN procedure, 37-50

DROP_MASTER_REPGROUP procedure, 37-51

DROP_MASTER_REPOBJECT procedure, 37-52

DROP_PRIORITY procedure, 37-53

DROP_PRIORITY_CHAR procedure, 37-55

DROP_PRIORITY_datatype procedure, 37-55

DROP_PRIORITY_DATE procedure, 37-55

DROP_PRIORITY_GROUP procedure, 37-54

DROP_PRIORITY_NUMBER procedure, 37-55

DROP_PRIORITY_VARCHAR2 procedure, 37-55

DROP_SITE_PRIORITY procedure, 37-57

DROP_SITE_PRIORITY_SITE procedure, 37-58

DROP_SNAPSHOT_REPGROUP procedure, 37-59

DROP_SNAPSHOT_REPOBJECT procedure, 37-60

DROP_UNIQUE_RESOLUTION procedure, 37-61

DROP_UPDATE_RESOLUTION procedure, 37-61

EXECUTE_DDL procedure, 37-63

GENERATE_REPLICATION_SUPPORT procedure, 37-64

GENERATE_SNAPSHOT_SUPPORT procedure, 37-66

MAKE_COLUMN_GROUP procedure, 37-68

PURGE_MASTER_LOG procedure, 37-69

PURGE_STATISTICS procedure, 37-70

REFRESH_SNAPSHOT_REPGROUP procedure, 37-71

REGISTER_SNAPSHOT_REPGROUP procedure, 37-72

REGISTER_STATISTICS procedure, 37-74

RELOCATE_MASTERDEF procedure, 37-75

REMOVE_MASTER_DATABASES procedure, 37-76

REPCAT_IMPORT_CHECK procedure, 37-77

RESUME_MASTER_ACTIVITY procedure, 37-78

SEND_OLD_VALUES procedure, 37-79

SET_COLUMNS procedure, 37-36, 37-81

SUSPEND_MASTER_ACTIVITY procedure, 37-83

SWITCH_SNAPSHOT_MASTER procedure, 37-83

UNREGISTER_SNAPSHOT_REPGROUP procedure, 37-84

VALIDATE procedure, 37-85

DBMS_REPCAT_ADMIN package, 38-1, 38-2

GRANT_ADMIN_ANY_SCHEMA procedure, 38-3

GRANT_ADMIN_SCHEMA procedure, 38-3

REGISTER_USER_REPGROUP procedure, 38-4

REVOKE_ADMIN_ANY_SCHEMA procedure, 38-6

REVOKE_ADMIN_SCHEMA procedure, 38-7

UNREGISTER_USER_REPGROUP procedure, 38-8

DBMS_REPCAT_INSTANTIATE package, 39-1, 39-2

DROP_SITE_INSTANTIATION procedure, 39-3

INSTANTIATE_OFFLINE function, 39-3

INSTANTIATE_OFFLINE_REPAPI function, 39-6

INSTANTIATE_ONLINE function, 39-9

DBMS_REPCAT_RGT package, 40-1, 40-2

ALTER_REFRESH_TEMPLATE procedure, 40-4

ALTER_TEMPLATE_OBJECT procedure, 40-6

ALTER_TEMPLATE_PARM procedure, 40-9

ALTER_USER_AUTHORIZATION procedure, 40-11

ALTER_USER_PARM_VALUE procedure, 40-12

COMPARE_TEMPLATES function, 40-15

COPY_TEMPLATE function, 40-16

CREATE_OBJECT_FROM_EXISTING function, 40-18

CREATE_REFRESH_TEMPLATE function, 40-20

CREATE_TEMPLATE_OBJECT function, 40-22

CREATE_TEMPLATE_PARM function, 40-26

CREATE_USER_AUTHORIZATION function, 40-28

CREATE_USER_PARM_VALUE function, 40-29

DELETE_RUNTIME_PARMS procedure, 40-32

DROP_ALL_OBJECTS procedure, 40-33

DROP_ALL_TEMPLATE_PARMS procedure, 40-34

DROP_ALL_TEMPLATE_SITES procedure, 40-35

DROP_ALL_TEMPLATES procedure, 40-36

DROP_ALL_USER_AUTHORIZATIONS procedure, 40-36

DROP_ALL_USER_PARM_VALUES procedure, 40-37

DROP_REFRESH_TEMPLATE procedure, 40-39

DROP_SITE_INSTANTIATION procedure, 40-40

DROP_TEMPLATE_OBJECT procedure, 40-41

DROP_TEMPLATE_PARM procedure, 40-43

DROP_USER_AUTHORIZATION procedure, 40-44

DROP_USER_PARM_VALUE procedure, 40-45

GET_RUNTIME_PARM_ID function, 40-46

INSERT_RUNTIME_PARMS procedure, 40-47

INSTANTIATE_OFFLINE function, 40-49

INSTANTIATE_OFFLINE_REPAPI function, 40-51

INSTANTIATE_ONLINE function, 40-54

LOCK_TEMPLATE_EXCLUSIVE procedure, 40-57

LOCK_TEMPLATE_SHARED procedure, 40-57

DBMS_REPUTIL package, 41-1, 41-2

FROM_REMOTE function, 41-4

GLOBAL_NAME function, 41-5

MAKE_INTERNAL_PKG procedure, 41-5

REPLICATION_IS_ON function, 41-4

REPLICATION_OFF procedure, 41-3

REPLICATION_ON procedure, 41-3

SYNC_UP_REP procedure, 41-6

DBMS_RESOURCE_MANAGER package, 42-1

DBMS_RESOURCE_MANAGER_PRIVS package, 43-1

DBMS_RLS package, 44-1

DBMS_ROWID package, 45-1

DBMS_SESSION package, 46-1

DBMS_SHARED_POOL package, 47-1

DBMS_SNAPSHOT package, 48-2

and DBMS_MVIEW as synonym for, 22-1

BEGIN_TABLE_REORGANIZATION procedure, 48-3

DBMS_MVIEW package, 48-1

END_TABLE_REORGANIZATION procedure, 48-3

I_AM_A_REFRESH function, 48-4

PURGE_DIRECT_LOAD_LOG procedure, 48-4

PURGE_LOG procedure, 48-5

PURGE_SNAPSHOT_FROM_LOG procedure, 48-6

REFRESH procedure, 48-8

REFRESH_ALL_MVIEWS procedure, 48-11

REFRESH_DEPENDENT procedure, 48-12

REGISTER_SNAPSHOT procedure, 48-14

UNREGISTER_SNAPSHOT procedure, 48-16

DBMS_SPACE package, 49-1

DBMS_SPACE_ADMIN package, 50-1

DBMS_SQL package

locating errors, 51-31

DBMS_STATS package, 52-1

DBMS_TRACE package, 53-1

DBMS_TRANSACTION package, 54-1

DBMS_TTS package, 55-1

DBMS_UTILITY package, 56-1

DDL. See data definition language

DEBUG_EXPTOC package, 57-1

DEFDEFAULTDEST view

adding destinations to, 11-4

removing destinations from, 11-4, 11-5

deferred transactions

DefDefaultDest table

removing destinations from, 11-5

DEFDEFAULTDEST view

adding destination to, 11-4

removing destinations from, 11-4

deferred remote procedure calls (RPCs)

argument types, 10-4

argument values, 10-7

arguments to, 9-5

building, 9-3

executing immediately, 11-13

deleting from queue, 11-6

re-executing, 11-9

scheduling execution, 11-19

starting, 9-7

DEFERROR view

deleting transactions from, 11-5

deployment templates

alter object, 40-6

alter parameters, 40-9

alter template, 40-4

alter user authorization, 40-11

alter user parameter values, 40-12

compare templates, 40-15

copy template, 40-16

create object from existing, 40-18

create template, 40-20

drop site instantiation, 39-3

objects

offline instantiation, 39-3, 39-6, 40-49, 40-51

online instantiation, 39-9, 40-54

parameters

runtime parameters

sites

user authorizations

user parameter values

creating, 40-29

dropping, 40-45

dropping all, 40-37

DES (Data Encryption Standard), 23-1

DESC_TAB datatype, 51-30

DESDecrypt procedure, 23-3

DESEncrypt procedure, 23-2

differences

between tables, 34-3

rectifying, 34-6

disabling

propagation, 11-21

dynamic SQL

anonymous blocks and, 51-2

DBMS_SQL functions, using, 51-2

errors, locating, 51-31

execution flow in, 51-4

ehlo()

function of UTL_SMTP, 65-6

email

sending with UTL_SMTP, 65-1

errors

locating in dynamic SQL, 51-31

returned by DBMS_ALERT package, 16-3

execution flow

in dynamic SQL, 51-4

features

new, xxxvii

filenames

normalization of with DBMS_BACKUP_RESTORE, 6-2

fine-grained access control

DBMS_RLS package, 44-1

flush()

as a function of UTL_TCP, 66-12

FORCE parameter

and job-to-instance affinity, 17-12

get_host_address()

function of UTL_INADDR, 62-2

get_raw(), get_text(), get_line()

as a function UTL_TCP, 66-11

helo()

function of UTL_SMTP, 65-5

importing

object groups

offline instantiation and, 24-4, 24-7

snapshots

offline instantiation and, 25-3, 25-5

status check, 37-77

internet addressing

using UTL_INADDR, 62-1

jobs

queues for

removing jobs from, 11-23

LOBs

DBMS_LOB package, 18-1

mail()

function of UTL_SMTP, 65-6

master definition sites

master groups

resuming replication activity, 37-78

master sites

creating, 37-7

dropping, 37-76

propagating changes between, 11-19

materialized views

refreshing with DBMS_MVIEW, 22-1

migration

post-migration actions, 6-1, 23-1

national language support

NCLOBs, 18-3

new features, xxxvii

noop()

function of UTL_SMTP, 65-12

objects

adding to snapshot sites, 37-42

altering, 37-17

creating, 37-38

for master group, 37-37

for master sites, 37-38

for snapshot sites, 37-42

dropping

snapshot site, 37-60

generating replication support for, 37-64

offline instantiation

replicated object groups, 24-3, 24-4, 24-5, 24-7, 24-8

snapshots, 25-3, 25-5

open_connection()

as a function of UTL_TCP, 66-3

function of UTL_SMTP, 65-3

open_data(), write_data(), write_raw_data(), close_data()

functions of UTL_SMTP, 65-9

OR REPLACE clause

for creating packages, 1-3

Oracle Advanced Queuing (Oracle AQ)

DBMS_AQADM package, 5-1

OUTLN_PKG package, 58-1

package overview, 1-2

package variables

i_am_a_refresh, 48-4

packages

creating, 1-3

referencing, 1-5

where documented, 1-6

plan stability, 58-1

PL/SQL

datatypes, 12-6

numeric codes for, 12-9

preface

conventions table sample, xxxix

Send Us Your Comments, xxxiii

priority groups

adding members to, 37-9

altering members

removing members from, 37-53, 37-55

site priority groups

adding members to, 37-10

propagation

altering method, 37-24

disabling, 11-21

of changes

propagation

propagator

registering, 11-16

purging

DBA_REPCATLOG table, 37-69

queuing

DBMS_AQADM package, 5-1

quiescing

master groups, 37-83

quit()

function of UTL_SMTP, 65-13

rcpt()

function of UTL_SMTP, 65-7

read_line()

as a function of UTL_TCP, 66-9

read_raw()

as a function of UTL_TCP, 66-6

read_text()

as a function of UTL_TCP, 66-8

rectifying

tables, 34-6

refresh

snapshot sites, 37-71

snapshots, 48-8, 48-11, 48-12

refresh groups

adding members to, 35-3

refresh interval

refreshing

removing members from, 35-10

registering

propagator for local database, 11-16

replicated object groups

offline instantiation of, 24-3, 24-4, 24-5, 24-7, 24-8

replicated objects

dropping from master sites, 37-52

replication

disabling, 41-3

enabling, 41-3

reply, replies

functions of UTL_SMTP, 65-3

resuming replication activity, 37-78

ROWID datatype

DBMS_ROWID package, 45-1

extended format, 45-12

rset()

function of UTL_SMTP, 65-11

SDO_ADMIN package, 1-15

SDO_GEOM package, 1-15

SDO_MIGRATE package, 1-15

SDO_TUNE package, 1-15

Send Us Your Comments, xxxiii

set_disabled, 11-21

site priority

altering, 37-22

site priority groups

adding members to, 37-10

creating

syntax, 37-47

dropping, 37-57

removing members from, 37-58

snapshot groups

creating, 37-41

snapshot logs

master table

purging, 48-4, 48-5, 48-6

snapshot sites

changing masters, 37-83

dropping, 37-59

propagating changes to master, 11-19

refreshing, 37-71

snapshots

generating support for, 37-66

offline instantiation of, 25-3, 25-5

refreshing, 48-8, 48-11, 48-12

SQL statements

larger than 32 KB, 51-12

SQL*Plus

creating a sequence, 1-5

statistics

collecting, 37-74

purging, 37-70

status

propagation, 11-7

stored outlines

OUTLN_PKG package, 58-1

tables

comparing, 34-3

rectifying, 34-6

table items as arrays, 51-15

TimeScale package, 1-16

TimeSeries package, 1-17

TPC/IP

as supported by UTL_TCP, 66-1

TRACETAB.SQL, 53-3

TSTools package, 1-20

upgrading

post-upgrade actions, 6-1, 23-1

UTL_COLL package, 59-1

UTL_FILE package, 60-1

UTL_HTTP package, 61-1

UTL_INADDR package, 62-1

UTL_PG package, 1-21

UTL_RAW package, 63-1

UTL_REF package, 64-1

UTL_SMTP package, 65-1

UTL_TCP package, 66-1

Vir_Pkg package, 1-22

vrfy()

function of UTL_SMTP, 65-11

write_line()

as a function of UTL_TCP, 66-11

write_raw()

as a function of UTL_TCP, 66-7

write_text()

as a function of UTL_TCP, 66-9