SQL*Module for Ada Programmer's Guide
ContentsOpens a new window
Opens a new window
Page 15 of 15

Index

AOpens a new window  BOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  FOpens a new window  IOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  ROpens a new window  SOpens a new window  TOpens a new window  UOpens a new window  VOpens a new window  WOpens a new window 

Symbols

@ operator
in SQL*Plus, 3.2Opens a new window

A

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

B

BIOpens a new window 
binding
command-line option, 5.8.2Opens a new window
early, 1.2Opens a new window, 3.6Opens a new window
late, 1.2Opens a new window, 3.6Opens a new window
BINDING command-line option, 3.6Opens a new window

C

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

D

DAOpens a new window  DEOpens a new window  DIOpens a new window  DYOpens a new window 
database concepts for host application developer, 4.1Opens a new window
datatypes
conversion, 1.1.3Opens a new window
SQL, 2.3Opens a new window
declaring a cursor, 2.1Opens a new window
DEPARTMT.SQL script, 6.2.1.2Opens a new window
DISCONNECT statement, 2.9Opens a new window
Dynamic SQL, 3.8Opens a new window

E

EAOpens a new window  EMOpens a new window  ENOpens a new window  EROpens a new window 
early binding, 1.2Opens a new window, 3.6Opens a new window
EMROLMNT.SQL script, 6.2.1.6Opens a new window
ENABLE THREADS statement, 2.10.1Opens a new window
encoding scheme, 4.9Opens a new window
error messages, 2.7.1Opens a new window
handling of, 1.1.2Opens a new window, 4.2Opens a new window
ERRORS
command-line option, 5.8.4Opens a new window

F

FIOpens a new window 
filename extension default values, 5.6Opens a new window
files
input, 5.6Opens a new window
output, 5.7Opens a new window
filetype, 5.6Opens a new window
FIPS
command-line option, 5.8.5Opens a new window
flagger, PrefaceOpens a new window

I

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

L

LAOpens a new window  LIOpens a new window  LNOpens a new window  LTOpens a new window 
LANGUAGE clause, 2.2.1.2Opens a new window
late binding, 1.2Opens a new window, 3.6Opens a new window
linking, 5.9Opens a new window
listing file output from SQL*Module, 5.7.3Opens a new window
listing options and default values, 5.3.1Opens a new window
LNAME
command-line option, 5.8.7Opens a new window
LTYPE
command-line option, 5.8.8Opens a new window

M

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

N

NAOpens a new window  NLOpens a new window  NUOpens a new window 
named parameter association, 2.2.3.3Opens a new window
NLS parameter
NLS_LANG, 4.9Opens a new window
null value
concept of, 4.1Opens a new window
handling, 4.4Opens a new window
indicator variable shows null, 2.6Opens a new window
Number of Rows Processed, obtaining, 4.3Opens a new window

O

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

P

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

R

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

S

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

T

TEOpens a new window  TIOpens a new window  TOOpens a new window 
terminal encoding scheme, 4.9Opens a new window
time stamp, 3.6Opens a new window
top-level procedure, 3.3Opens a new window

U

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

V

VAOpens a new window 
values of command-line options, 5.4Opens a new window

W

WHOpens a new window  WIOpens a new window 
WHERE CURRENT OF clause, 2.4Opens a new window
whitespace
not present in option lists, 5.8Opens a new window
whitespace in command-line options, 5.8Opens a new window
with context clause
for ADA, 2.1.1Opens a new window, 6.1Opens a new window
WITH INTERFACE clause
about, 3.9Opens a new window
Previous PageOpens a new window
Page 15 of 15
Next Page