SQL*Module for Ada Programmer's Guide
Release 8.0
A58231-01

Product

Contents

Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

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, viii

Ada example for VAX/VMS, 5-22

angle brackets, ix

anonymous blocks, 3-2

anonymous blocks in PL/SQL, 3-8

Application Programming Interfaces (APIs), 5-13

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, ix

brackets, viii

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, viii

COURSES.SQL script, 6-7

CREATE PROCEDURE command, 3-3

cursor

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, vii

DEPARTMT.SQL script, 6-5

DISCONNECT statement, 2-19

dots, ix

Dynamic SQL, 3-12

E

early binding, 1-9, 3-7

ellipsis, ix

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, vi

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

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, viii

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, viii

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, iii

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, iii

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, vi

running the compiler, 5-4

standards conformance, vi

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, viii

standalone procedure, 3-4

standards conformance, vi

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, viii

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, ix

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

words