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