Index

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

Symbols

@ operator
in SQL*Plus, 3.2

A

Ada
example code, 6.3
named parameter association, 2.2.3.3
positional parameter association, 2.2.3.3
Ada example for VAX/VMS, 5.9.1
anonymous blocks, 3.1.1
anonymous blocks in PL/SQL, 3.6
Application Programming Interfaces (APIs), 5.8
Arrays as Procedure Arguments, 4.8
AUTHORIZATION clause, 2.2.1.3
AUTO_CONNECT
command-line option, 5.8.1

B

BINDING
command-line option, 5.8.2
binding
early, 1.2, 3.6
late, 1.2, 3.6
BINDING command-line option, 3.6

C

case sensitivity in program names, option names, and values, 5.3
case-sensitive characters
in names of executables, 5.3
in package and procedure names, 3.5
code page, 4.9
command-line option value lists, 5.4.1
command-line options
about, 5.8
case-sensitive characters in, 3.5
CONFIG, 5.5
specifying an option, 5.4
whitespace used in, 5.8
Comments, 2.5.1
comments
C-style, 2.5.1
not allowed in a configuration file, 5.5
SQL-style, 2.5.1
compiling and linking
about, 5.9
CONFIG
command-line option, 5.8.3
CONFIG command-line option, 5.5
configuration files
system, 5.4.2, 5.5
user, 5.4.2, 5.5
CONNECT statement, 2.8
connecting to a database
AUTHORIZATION clause and, 2.2.1.3
calling RPC stubs and, 3.11
CONTEXT ALLOCATE statement, 2.10.3
CONTEXT FREE statement, 2.10.4
conventions
for text in a module file, 2.5
COURSES.SQL script, 6.2.1.5
CREATE PROCEDURE command, 3.2
cursor
concept of, 4.1
declaring, 2.1
name of, 2.2.2
namespace for, 2.2.2
syntax of, B.1.2
using in queries, 4.5
cursor declarations, 2.2.2
cursor variable
closing, 3.7.4
cursor variable parameters, 3.7.1
cursor variables, 2.2.2, 3.7, 4.5
allocating, 3.7.2
must use late binding, 3.7.3
not available for Ada, 3.7
opening, 3.7.3
opening in a standalone stored procedure, 3.7.3.1
return types, 3.7.3.2
cursor variables, restrictions on, 3.7.5

D

database concepts for host application developer, 4.1
datatypes
conversion, 1.1.3
SQL, 2.3
declaring a cursor, 2.1
DEPARTMT.SQL script, 6.2.1.2
DISCONNECT statement, 2.9
Dynamic SQL, 3.8

E

early binding, 1.2, 3.6
EMROLMNT.SQL script, 6.2.1.6
ENABLE THREADS statement, 2.10.1
encoding scheme, 4.9
error messages, 2.7.1
handling of, 1.1.2, 4.2
ERRORS
command-line option, 5.8.4

F

filename extension default values, 5.6
files
input, 5.6
output, 5.7
filetype, 5.6
FIPS
command-line option, 5.8.5
flagger, Preface

I

INAME
command-line option, 5.8.6
indicator parameters, 2.6, 3.9
definition of, 4.4
truncation indicated by, 2.6
values greater than zero, 4.4.1
indicator variables, 4.4.1
concept of, 4.1
used to show nulls, 2.6
input files, 5.6
INSTRUCS.SQL script, 6.2.1.3
interface procedures
definition of, 1.2
files, 1.2
stubs, 1.2

L

LANGUAGE clause, 2.2.1.2
late binding, 1.2, 3.6
linking, 5.9
listing file output from SQL*Module, 5.7.3
listing options and default values, 5.3.1
LNAME
command-line option, 5.8.7
LTYPE
command-line option, 5.8.8

M

makefile, 5.2
MAPPING
command-line option, 5.8.9
MAXLITERAL
command-line option, 5.8.10
MKTABLES.SQL script, 6.2.1.1
mode of a parameter in PL/SQL, 3.1.1
module
cursor declarations in, 2.1
definition of, 2.1
preamble to, 2.1
procedures in, 2.1
structure of, 2.2
MODULE clause, 2.2.1.1
module file
text conventions in, 2.5
Module Language
defined by ANSI committee, 1.1.3
sample program, 2.1.1, 6.2
syntax diagrams for, B.1
Module Language Sample Program, 6.2.2
Multi-tasking, 2.10
Multi-tasking Example, 2.11
Multi-tasking Restrictions, 2.10.5

N

named parameter association, 2.2.3.3
NLS parameter
NLS_LANG, 4.9
null value
concept of, 4.1
handling, 4.4
indicator variable shows null, 2.6
Number of Rows Processed, obtaining, 4.3

O

ONAME
command-line option, 5.8.11
OPEN command
not used for cursor variables, 2.4
opening a cursor variable, 3.7.3
operating system command line, 5.2
options on command line, 5.4
Oracle Call Interface (OCI)
anonymous PL/SQL blocks and, 3.6
OUTPUT
command-line option, 5.8.12
output file default name for Ada, 5.7.1.1
output files
for SQL*Module, 5.7

P

packages, 3.3
parameter list, 2.2.3.2
password
in AUTHORIZATION clause, 2.2.1.3
supplied at runtime, 2.2.1.3
PL/SQL
about, 3.1
datatypes
in a stored procedure definition, 3.9
functions
return values for, 3.9.3.2
mode of a parameter, 3.1.1
sample program, 6.2.3
PL/SQL source files output from SQL*Module, 5.7.4
PNAME
command-line option, 5.8.13
positional parameter association, 2.2.3.3
preamble, 2.2.1
syntax of, B.1.1
to a module, 2.1
precompiler default values, 5.4.2
precompilers, 3.6
privileges
database, 2.2.1.3
when running SQL*Module application, 2.2.1.3
procedure definitions, 2.2.3
procedure name, 2.2.3.1
procedures, 3.1.1
case of generated output code files, 3.5
in a module, 2.1
standalone, 3.3
stored, 3.2
top-level, 3.3
program structure, 4.1
program structure of a SQL*Module application, 4.1

R

reserved words, C.1
rows_processed function, 4.3
RPC, 3.9
BINDING command-line option used with, 3.6
call to PL/SQL, 3.9
RPC_GENERATE
command-line option, 5.8.14
RPC_GENERATE command-line option, 5.8.2
running the Mod*SQL compiler, 5.2.1
running the SQL*Module compiler, 5.2

S

SAMeDL, 1.1.3
sample application DEMCALSP.A, 6.3.2
sample application DEMOHOST.A, 6.3.1
sample programs
on-line location of, 6.2
sample tables
on-line location of, 6.2
schema name required when running SQL*Module, 5.2.1
SELECT_ERROR
command-line option, 5.8.15
semicolon
does not terminate cursor declaration, 2.2.2
SET CONNECTION statement, 2.8.1
SNAME
command-line option, 5.8.16
source code output file, 5.7.1
specification files, 1.1.3, 4.6
in Ada, 2.1.1
SQL
commands
allowed in Module Language, 2.4
list of, 2.4
datatypes
about, 2.3
in the WITH INTERFACE clause, 3.9, 3.9
identifier
as a cursor name, 2.2.2
in module preamble, 2.2.1.1
SQL Ada Module Description Language, 1.1.3
SQL*Module
about, 1.1
development using Module Language, 1.1.3
executable names, 5.3
FIPS flagger, Preface
running the compiler, 5.2
standards conformance, Preface
supported features, 1.3
SQL*Plus
creating stored procedures with, 3.2
storing packages in a database, 5.1.1
SQL_CONTEXT datatype, 2.10.2
SQL_STANDARD package, 6.1
SQL92 syntax, 2.2.3.3
SQLCHECK
command-line option, 5.8.18
SQLCODE
concept of, 4.1
in the WITH INTERFACE clause, 3.9
parameter, 2.7
return values, 4.2.1
standard type, 6.1.1
SQLCODE parameter, 4.2.1
SQLLIB, 5.9
SQLSTATE
concept of, 4.1
declaring, 4.2.3
in the WITH INTERFACE clause, 3.9
parameter, 2.7
standard type, 6.1.2
SQLSTATE parameter, 4.2.3
SQLSTATE status variable
predefined status codes and conditions, 4.2.3
standalone procedure, 3.3
standards conformance, Preface
status parameters
about, 2.7
in the WITH INTERFACE clause, 3.9
STORE_PACKAGE
command-line option, 5.8.17
STORE_PACKAGE command-line option
does a CREATE or REPLACE PACKAGE, 5.8.17
stored packages, 3.3
stored procedures
about, 3.2
created with SQL*Module, 3.10
string literal
on one line, 2.5
STUDENTS.SQL script, 6.2.1.4
syntax diagrams for Module Language, B.1
system configuration file, 5.4.2
system-specific Oracle documentation
Ada default filenames, 5.7.2.1
Ada default names, 5.7.1.1
case-sensitive command-line options, 3.5
filename extensions, 5.8
filenames and extensions, 5.6
invoking SQL*Module, 5.2
SQL_STANDARD package for Ada, 6.1
system configuration files, 5.5
system-specific references, E.1

T

terminal encoding scheme, 4.9
time stamp, 3.6
top-level procedure, 3.3

U

user configuration file, 5.4.2
USERID
command-line option, 5.8.19
compiling Module Language files, 5.2.1
generating interface procedure files, 5.2.1
username
in AUTHORIZATION clause, 2.2.1.3

V

values of command-line options, 5.4

W

WHERE CURRENT OF clause, 2.4
whitespace
not present in option lists, 5.8
whitespace in command-line options, 5.8
with context clause
for ADA, 2.1.1
for Ada, 6.1
WITH INTERFACE clause
about, 3.9