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