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.1.2, 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.3

PLSQL connection attribute, 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

In-Memory Database Cache (IMDB Cache), use from PL/SQL, 2.7.5

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.1.2, 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 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

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