Index

A  B  C  D  E  F  G  I  L  N  O  P  Q  R  S  T  U  V  W 

Symbols

%BULK_EXCEPTIONS attribute, 2.7.3, 5.5.4
%BULK_ROWCOUNT attribute, 5.5.1
%FOUND attribute, 9
%ISOPEN attribute, 9
%NOTFOUND attribute, 5.4.1, 9
%ROWCOUNT attribute, 5.4.2, 9
%ROWTYPE attribute, 2.2
%TYPE attribute, 2.2

A

access control
connections, 7.4.1
for TimesTen built-in functions, 7.4.3
granting and revoking privileges, 7.1.2
impact for PL/SQL, 7
privileges for procedures, functions, packages, 7.1
SQL operations, 7.2
supplied packages and system views, 7.4.2
ALTER SESSION, 6.2
anonymous blocks, 2.1
array binding
associative array binding, 3.2.3.3
bulk binding, 2.7.3
associative arrays (index-by tables)
binding, 3.2.3.3
example, 5.3.3
using, 3.2.3.1
audiences for this document, 1.3
AUTHID clause, 5.8, 7.3

B

BINARY_INTEGER type, 3.2.2.1
bind parameter--see parameters
bind variables--see parameters
blocks, 2.1
built-in functions (TimesTen)
access control, 7.4.3
calling via EXECUTE IMMEDIATE, 2.7.2, 5.6.4, 5.6.4
bulk binding
%BULK_EXCEPTIONS attribute, 2.7.3, 5.5.4
BULK COLLECT INTO with cursors, 5.5.3
BULK COLLECT INTO with queries, 5.5.2
BULK COLLECT INTO with RETURNING INTO, 5.7.2
examples, 5.5
FORALL statement, 2.7.3
overview, 2.7.3
SAVE EXCEPTIONS clause, 2.7.3, 5.5.4

C

cache features, use from PL/SQL, 2.7.5
CALL statement, calling functions and procedures, 2.5
CASE statement, 2.4.1
collections, 3.2.3.1
compilation
conditional compilation, use of PLSQL_CCFLAGS, 6.2
conditional, use of UTL_IDENT and TT_DB_VERSION, 8
DBMS_UTILITY.COMPILE_SCHEMA, 8
DBMS_UTILITY.INVALIDATE, optionally modify compiler parameter settings, 8
implicit, 7.1.1
PLSCOPE_SETTINGS for compilation cross-reference information, 6.2
PLSQL_OPTIMIZE_LEVEL for optimization level, 6.2
UTL_RECOMP package to recompile invalid modules, 8
components of PL/SQL, overview, 1.2
composite data types, 3.2.3
conditional control, 2.4.1
connection attributes
first connection attributes, 6.2
general connection attributes, 6.2
PLSCOPE_SETTINGS attribute, 6.2
PLSQL attribute, 6.2
PLSQL_CCFLAGS attribute, 6.2
PLSQL_CONN_MEM_LIMIT attribute, 6.2
PLSQL_MEMORY_ADDRESS attribute, 6.2
PLSQL_MEMORY_SIZE attribute, 6.2
PLSQL_OPTIMIZE_LEVEL attribute, 6.2
PLSQL_TIMEOUT attribute, 6.2
constants and variables, 2.2
CONTINUE statement, 2.4.3
conversion--see type conversion
cursors
closed at end of transaction, 2.12
cursor attributes, 9
cursor FOR loop, example, 5.4.3
examples, 5.4
REF CURSORs, 3.2.4
use in PL/SQL, 2.8

D

data types
associative arrays (index-by tables), 3.2.3.1
categories, 3.2.1
collections, 3.2.3.1
composite data types, 3.2.3
conversion between application types and PL/SQL or SQL types, 3.3.2
conversion between PL/SQL and SQL, 3.4.1
conversion between PL/SQL types, 3.3.1
differences in TimesTen, 3.4
index-by tables (associative arrays), 3.2.3.1
nested tables, 3.2.3.1
non-supported types, 3.4.3
overview of what is supported, 3
PLS_INTEGER and BINARY_INTEGER, 3.2.2.1
PL/SQL types, 3.2
records, 3.2.3.2
REF CURSORs, 3.2.4
ROWID, 3.2.2.3
scalar types, 3.2.2
SIMPLE_INTEGER, 3.2.2.2
type environments, 3.1
varrays, 3.2.3.1
DBMS_LOB package, 8
DBMS_LOCK package, 8
DBMS_OUTPUT package, 8
DBMS_PREPROCESSOR package, 8
DBMS_RANDOM package, 8
DBMS_SQL package, 8
DBMS_UTILITY package, 8
DDL statements, 2.7.2
definer’s rights, 5.8, 7.3
demo applications, 1.4
differences in TimesTen
data type considerations, 3.4
exception handling and behavior, 4.4
execution of PL/SQL from SQL, 1.2.2.2
PL/SQL language element and feature support, 9
SQL statements in PL/SQL blocks, 1.2.2.1
transaction behavior, 2.12
DML returning, 2.7.4, 5.7
DML statements, 2.7.1
duplicate parameters, 2.6.1
dynamic SQL
DBMS_SQL package, 8
EXECUTE IMMEDIATE examples, 5.6
EXECUTE IMMEDIATE usage, 2.7.2

E

enabling PL/SQL
checking whether it is enabled, 6.1.2
errors
error messages, differences vs. Oracle, 4.4.2
exception types, 4.1.2
RAISE statement, 4.2.2.1
RAISE_APPLICATION_ERROR procedure, 4.2.2.2
show errors in ttIsql, 4.3
SQLCODE built-in function, 4.2.2.1, 4.4.2
SQLERRM built-in function, 4.2.2.1, 4.4.2
transaction and rollback behavior, differences vs. Oracle, 4.4.1
trapping predefined exceptions, 4.2.1
trapping user-defined exceptions, 4.2.2
understanding exceptions, 4.1
warnings (not supported), 4.4.3
examples
bind variables, 5.3
bulk binding, 5.5
cursor FOR loop, 5.4.3
cursors, 5.4
dynamic SQL, 5.6
FETCH statement, 5.4.1
INSERT statement, 5.2
query a system view, 5.9
RETURNING INTO, 5.7
SELECT statement, 5.1
exceptions--see errors
EXECUTE IMMEDIATE statement
examples, 5.6
usage, 2.7.2

F

features, overview, 1.1
FETCH statement, example, 5.4.1
first connection attributes, 6.2
FOR loop, 2.4.2
FORALL statement, 2.7.3, 5.5.1
functions
access control, 7.1
basic usage and example, 2.9
SQL functions, from PL/SQL, 2.3
supported ways to execute, 2.5

G

general connection attributes, 6.2
granting privileges, 7.1.2

I

IF-THEN-ELSE statement, 2.4.1
IN OUT parameters, 2.6.2
IN parameters, 2.6.2
index-by tables (associative arrays)
binding, 3.2.3.3
using, 3.2.3.1
INSERT statement, example, 5.2
installing PL/SQL (ttmodinstall), 6.1.1
integer types
BINARY_INTEGER, 3.2.2.1
PLS_INTEGER, 3.2.2.1
SIMPLE_INTEGER, 3.2.2.2
invoker’s rights, 5.8, 7.3
iterative control, 2.4.2

L

language elements and features, support, 9
LOBs
DBMS_LOB package, 8
overview, 2.7.6
using in PL/SQL, 2.7.6

N

nested tables, 3.2.3.1
NLS_DATE_FORMAT, 3.4.2
NLS_TIMESTAMP_FORMAT, 3.4.2
non-ASCII names (not supported), 9
non-uppercase names (not supported), 9

O

operations of PL/SQL, overview, 1.2
OUT parameters, 2.6.2
overview
components and operations, 1.2
features, 1.1

P

packages
access control, 7.1
concepts, 2.10.1
creating and using, 2.10.2
TimesTen-supplied packages, 8
parameters
binding, 2.6.1
duplicate parameters, 2.6.1
examples using bind variables, 5.3
IN, 2.6.2
IN OUT, 2.6.2
OUT, 2.6.2
PLS_INTEGER type, 3.2.2.1
PLSCOPE_SETTINGS connection attribute, 6.2
PLSQL connection attribute, 6.2
PLSQL_CCFLAGS connection attribute, 6.2
PLSQL_CONN_MEM_LIMIT connection attribute, 6.2
PLSQL_MEMORY_ADDRESS connection attribute, 6.2
PLSQL_MEMORY_SIZE connection attribute, 6.2
PLSQL_OPTIMIZE_LEVEL connection attribute, 6.2
PLSQL_TIMEOUT connection attribute, 6.2
predefined exceptions
not supported by TimesTen, 4.4.4
supported by TimesTen, 4.2.1
privileges
for procedures, functions, packages, 7.1
granting and revoking, 7.1.2
privileges--also see access control
procedures
access control, 7.1
basic usage and example, 2.9
supported ways to execute, 2.5
programming features
conditional control, 2.4.1
continue, 2.4.3
iterative control, 2.4.2
public objects, 2.10.2

Q

queries, 2.7.1
Quick Start demo applications, 1.4

R

RAISE statement (exceptions), 4.2.2.1
RAISE_APPLICATION_ERROR procedure, 4.2.2.2
records, 3.2.3.2
REF CURSORs, 3.2.4
replication, PL/SQL DDL, not supported, 2.9.1
RETURNING INTO clause, 2.7.4, 5.7
revoking privileges, 7.1.2
ROWID type, 3.2.2.3

S

samples--see examples
SAVE EXCEPTIONS clause, 2.7.3, 5.5.4
security--see access control
SELECT statement, 2.7.1
SELECT statement, example, 5.1
show errors, ttIsql, 4.3
SIMPLE_INTEGER type, 3.2.2.2
sleep functionality, 8
SQL
DDL statements, 2.7.2
dynamic SQL, 2.7.2
static SQL, 2.7.1
SQL functions, from PL/SQL, 2.3
SQLCODE built-in function, 4.2.2.1, 4.4.2
SQLERRM built-in function, 4.2.2.1, 4.4.2
standalone subprograms (procedures and functions), 2.9
static SQL, 2.7.1
stored functions
access control, 7.1
basic usage and example, 2.9
supported ways to execute, 2.5
stored procedures
access control, 7.1
basic usage and example, 2.9
supported ways to execute, 2.5
subprograms
access control, 7.1
basic usage and example, 2.9
supported ways to execute, 2.5
supplied packages and system views
access control, 7.4.2
system view, querying, 5.9
synonyms
for packages, 2.10.3
for procedures and functions, 2.9.2

T

TimesTen Application-Tier Database Cache (TimesTen Cache), use from PL/SQL, 2.7.5
TimesTen built-in functions
access control, 7.4.3
calling via EXECUTE IMMEDIATE, 2.7.2, 5.6.4, 5.6.4
TO_CHAR function, 3.4.2
TO_DATE function, 3.4.2
transaction and rollback behavior, differences vs. Oracle, 4.4.1
transaction behavior, 2.12
trapping exceptions
predefined exceptions, 4.2.1
user-defined exceptions, 4.2.2
TT_DB_VERSION package, 8
TT_DECIMAL data type (unsupported), 3.4.1
TT_STATS package, 8
ttIsql, show errors, 4.3
ttmodinstall utility (install PL/SQL), 6.1.1
ttPLSQLMemoryStats built-in procedure, 6.2, 7.4.3, 9
ttSrcScan utility (check for unsupported features), 6.3
type conversion
between application types and PL/SQL or SQL types, 3.3.2
between PL/SQL and SQL, 3.4.1
between PL/SQL types, 3.3.1
differences in TimesTen, 3.4

U

unsupported features, check with ttSrcScan, 6.3
UTL_FILE package, 8
UTL_IDENT package, 8
UTL_RAW package, 8
UTL_RECOMP package, 8

V

variables and constants, 2.2
varrays, 3.2.3.1

W

warnings (not supported), 4.4.3
WHILE loop, 2.4.2
wrapping PL/SQL source code, 2.11