SQL*Module for Ada Programmer's Guide
Release 8.0

Part Number A58231-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

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-3

A

Ada
example code, 6-22
named parameter association, 2-12
positional parameter association, 2-12
typographic conventions for code, xiv
Ada example for VAX/VMS, 5-22
angle brackets, xv
anonymous blocks, 3-2
anonymous blocks in PL/SQL, 3-8
Arrays as Procedure Arguments, 4-9
AUTHORIZATION clause, 2-9
formal syntax of, B-2
AUTO_CONNECT
command-line option, 5-13

B

BINDING
command-line option, 5-14
binding
early, 1-9, 3-7
late, 1-9, 3-7
BINDING command-line option, 3-8
braces, xv
brackets, xiv

C

case sensitivity in program names, option names, and values, 5-5
case-sensitive characters
in names of executables, 5-5
in package and procedure names, 3-6
code page, 4-11
command-line option value lists, 5-6
command-line options
about, 5-11
case-sensitive characters in, 3-6
CONFIG, 5-8
specifying an option, 5-6
whitespace used in, 5-11
Comments, 2-15
comments
C-style, 2-15
not allowed in a configuration file, 5-8
SQL-style, 2-15
compiling and linking
about, 5-22
CONFIG
command-line option, 5-14
CONFIG command-line option, 5-8
configuration files
system, 5-7, 5-8
user, 5-7, 5-8
CONNECT statement, 2-18
connecting to a database
AUTHORIZATION clause and, 2-9
calling RPC stubs and, 3-20
CONTEXT ALLOCATE statement, 2-21
CONTEXT FREE statement, 2-21
conventions
for text in a module file, 2-14
used in this manual, xiv
COURSES.SQL script, 6-7
CREATE PROCEDURE command, 3-3
cursor
concept of, 4-2
declaring, 2-2
name of, 2-10
namespace for, 2-10
syntax of, B-3
using in queries, 4-8
cursor declarations, 2-10
cursor variable
closing, 3-11
cursor variable parameters, 3-9
cursor variables, 2-10, 3-9, 4-8
allocating, 3-9
must use late binding, 3-11
not available for Ada, 3-9
opening, 3-10
opening in a standalone stored procedure, 3-11
return types, 3-11
cursor variables, restrictions on, 3-12

D

database concepts for host application developer, 4-2
datatypes
conversion, 1-5
SQL, 2-12
declaring a cursor, 2-2
demo directory, xiii
DEPARTMT.SQL script, 6-5
DISCONNECT statement, 2-19
dots, xv
Dynamic SQL, 3-12

E

early binding, 1-9, 3-7
ellipsis, xv
EMROLMNT.SQL script, 6-8
ENABLE THREADS statement, 2-20
encoding scheme, 4-11
error messages, 2-18
handling of, 1-3, 4-2
ERRORS
command-line option, 5-14

F

filename extension default values, 5-9
files
input, 5-8
output, 5-9
filetype, 5-9
FIPS
command-line option, 5-15
flagger, xii

I

INAME
command-line option, 5-15
indicator parameters, 2-15, 3-13
definition of, 4-6
truncation indicated by, 2-16
values greater than zero, 4-8
indicator variables, 4-6
concept of, 4-2
used to show nulls, 2-16
input files, 5-8
INSTRUCS.SQL script, 6-6
interface procedures
definition of, 1-8
files, 1-8
stubs, 1-8

L

LANGUAGE clause, 2-8
late binding, 1-9, 3-7
linking, 5-22
listing file output from SQL*Module, 5-10
listing options and default values, 5-5
LNAME
command-line option, 5-16
LTYPE
command-line option, 5-16

M

makefile, 5-4
MAPPING
command-line option, 5-16
MAXLITERAL
command-line option, 5-17
MKTABLES.SQL script, 6-3
mode of a parameter in PL/SQL, 3-3
module
cursor declarations in, 2-2
definition of, 2-2
preamble to, 2-2
procedures in, 2-2
structure of, 2-7
MODULE clause, 2-8
module file
text conventions in, 2-14
Module Language
defined by ANSI committee, 1-5
sample program, 2-2, 6-2
syntax diagrams for, B-2
Module Language Sample Program, 6-10
Multi-tasking, 2-20
Multi-tasking Example, 2-22
Multi-tasking Restrictions, 2-21

N

named parameter association, 2-12
National Language Support (NLS), 4-10
NLS parameter
NLS_CURRENCY, 4-10
NLS_DATE_FORMAT, 4-10
NLS_DATE_LANGUAGE, 4-10
NLS_ISO_CURRENCY, 4-10
NLS_LANG, 4-11
NLS_LANGUAGE, 4-10
NLS_NUMERIC_CHARACTERS, 4-10
NLS_SORT, 4-10
NLS_TERRITORY, 4-10
NOT NULL
database constraint, 2-16
notational conventions, xiv
null value
concept of, 4-2
handling, 4-6
indicator variable shows null, 2-16
NOT NULL database constraint, 2-16
Number of Rows Processed, obtaining, 4-6

O

ONAME
command-line option, 5-17
OPEN command
not used for cursor variables, 2-14
opening a cursor variable, 3-10
operating system command line, 5-4
options on command line, 5-6
Oracle Call Interface (OCI)
anonymous PL/SQL blocks and, 3-8
OUTPUT
command-line option, 5-18
output file default name for Ada, 5-9
output files
for SQL*Module, 5-9

P

packages, 3-4
parameter list, 2-11
password
in AUTHORIZATION clause, 2-9
supplied at runtime, 2-9
PL/SQL
about, 3-2
datatypes
in a stored procedure definition, 3-13
functions
return values for, 3-18
mode of a parameter, 3-3
sample program, 6-19
typographic conventions for code, xiv
PL/SQL source files output from SQL*Module, 5-10
PNAME
command-line option, 5-19
positional parameter association, 2-12
preamble, 2-8
syntax of, B-3
to a module, 2-2
precompiler default values, 5-7
precompilers, 3-8
preface
Send Us Your Comments, ix
privileges
database, 2-9
when running SQL*Module application, 2-9
procedure definitions, 2-10
procedure name, 2-11
procedures, 3-2
case of generated output code files, 3-6
in a module, 2-2
standalone, 3-4
stored, 3-3
top-level, 3-4
program structure, 4-2
program structure of a SQL*Module application, 4-2

R

reserved words
Oracle, C-2
rows_processed function, 4-6
RPC, 3-13
BINDING command-line option used with, 3-8
call to PL/SQL, 3-13
RPC_GENERATE
command-line option, 5-19
RPC_GENERATE command-line option, 5-14
running the Mod*SQL compiler, 5-4
running the SQL*Module compiler, 5-4

S

SAMeDL, 1-5
sample application DEMCALSP.A, 6-40
sample application DEMOHOST.A, 6-22
sample programs
on-line location of, 6-3
sample tables
on-line location of, 6-3
schema name required when running SQL*Module, 5-5
SELECT_ERROR
command-line option, 5-20
semicolon
does not terminate cursor declaration, 2-10
Send Us Your Comments
boilerplate, ix
SET CONNECTION statement, 2-19
SNAME
command-line option, 5-20
source code output file, 5-9
specification files, 1-7, 4-8
in Ada, 2-4
SQL
commands
allowed in Module Language, 2-14
list of, 2-14
datatypes
about, 2-12
in the WITH INTERFACE clause, 3-13
identifier
as a cursor name, 2-10
in module preamble, 2-8
SQL Ada Module Description Language, 1-5
SQL*Module
about, 1-2
development using Module Language, 1-5
executable names, 5-5
FIPS flagger, xii
running the compiler, 5-4
standards conformance, xii
supported features, 1-11
SQL*Plus
creating stored procedures with, 3-3
storing packages in a database, 5-2
SQL_CONTEXT datatype, 2-21
SQL_STANDARD package, 6-2
SQL92 syntax, 2-11
SQLCHECK
command-line option, 5-21
SQLCODE
concept of, 4-2
in the WITH INTERFACE clause, 3-13
parameter, 2-17
return values, 4-3
standard type, 6-2
SQLCODE parameter, 4-2
SQLLIB, 5-22
SQLSTATE
concept of, 4-2
declaring, 4-3
in the WITH INTERFACE clause, 3-13
parameter, 2-17
standard type, 6-2
SQLSTATE parameter, 4-3
SQLSTATE status variable
predefined status codes and conditions, 4-6
square brackets, xiv
standalone procedure, 3-4
standards conformance, xii
status parameters
about, 2-17
in the WITH INTERFACE clause, 3-13
STORE_PACKAGE
command-line option, 5-20
STORE_PACKAGE command-line option
does a CREATE or REPLACE PACKAGE, 5-21
stored packages, 3-4
stored procedures
about, 3-3
created with SQL*Module, 3-18
string literal
on one line, 2-14
STUDENTS.SQL script, 6-7
syntax diagrams for Module Language, B-2
system configuration file, 5-7
system-specific Oracle documentation
Ada default filenames, 5-10
Ada default names, 5-9
case-sensitive command-line options, 3-6
filename extensions, 5-11
filenames and extensions, 5-9
invoking SQL*Module, 5-4
SQL_STANDARD package for Ada, 6-2
system configuration files, 5-8
system-specific references, E-2

T

terminal encoding scheme, 4-11
time stamp, 3-7
top-level procedure, 3-4
typographic conventions, xiv

U

user configuration file, 5-7
USERID
command-line option, 5-21
compiling Module Language files, 5-5
generating interface procedure files, 5-5
username
in AUTHORIZATION clause, 2-9

V

values of command-line options, 5-6
vertical bar, xv

W

WHERE CURRENT OF clause, 2-14
whitespace
not present in option lists, 5-11
whitespace in command-line options, 5-11
with context clause
for ADA, 2-4
for Ada, 6-2
WITH INTERFACE clause
about, 3-13
words
reserved, C-2

Go to previous page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback