SQL/Module for Ada Programmer’s Guide

Melnick J.

This book is a comprehensive user’s guide and reference for SQL’Mochile, an Oracle application development tool.This Guide includes a complete description of Module Language, an ANSI/ISO SQL standard for developing applications that access data stored in a relational database. Module Language uses parameterized procedures to encapsulate SQL statements. The procedures can then be called from an Ada application.This Guide also describes how you can use SQL*Module to call PL/SQL procedures stored in an Oracle database. A number of complete examples using Module Language. Ada code, and stored database procedures are provided.

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 9
Preface……Page 11
1 Introduction to SQL*Module……Page 17
Background……Page 18
Precompilers……Page 19
The Module Language Concept……Page 21
SQL*Module as an Interface Builder……Page 24
What SQL Statements are Not Supported by SQL*Modul………Page 27
2 Module Language……Page 29
An Example Module……Page 30
A Short Example Program in Ada……Page 32
Structure of a Module……Page 35
Preamble……Page 36
Procedure Definitions……Page 38
SQL Datatypes……Page 40
Text in a Module……Page 42
Indicator Parameters……Page 43
Status Parameters……Page 45
CONNECT Statement……Page 46
DISCONNECT Statement……Page 47
ENABLE THREADS……Page 48
Multi-tasking Restrictions……Page 49
Multi-tasking Example……Page 50
3 Accessing Stored Procedures……Page 51
Procedures……Page 52
Stored Procedures……Page 53
Accessing Stored Procedures……Page 54
Case of Package and Procedure Names……Page 56
Early and Late Binding……Page 57
Allocating a Cursor Variable……Page 59
Opening a Cursor Variable……Page 60
Closing a Cursor Variable……Page 61
Dynamic SQL……Page 62
Examples……Page 63
SQL Datatypes……Page 65
The Default WITH INTERFACE Clause……Page 66
Storing Module Language Procedures……Page 68
Connecting to a Database……Page 70
4 Developing the Ada Application……Page 71
SQLCODE……Page 72
SQLSTATE……Page 73
Indicator Variables……Page 76
Specification Files……Page 78
Arrays as Procedure Arguments……Page 79
National Language Support……Page 80
5 Running SQL*Module……Page 83
Output Files……Page 84
Determining the Input Source……Page 85
Running the Compiler……Page 86
Listing Options and Default Values……Page 87
Value Lists……Page 88
Default Values……Page 89
Input Files……Page 90
Source Code Output File……Page 91
Avoid Default Output Filenames……Page 92
Command-Line Options……Page 93
AUTO_CONNECT……Page 95
ERRORS……Page 96
INAME……Page 97
MAPPING……Page 98
ONAME……Page 99
OUTPUT……Page 100
RPC_GENERATE……Page 101
STORE_PACKAGE……Page 102
USERID……Page 103
An Example (Module Language)……Page 104
6 Demonstration Programs……Page 107
Sample Programs……Page 108
Sample Tables……Page 109
Module Language Sample Program……Page 116
Calling a Stored Procedure……Page 125
DEMOHOST.A……Page 128
DEMCALSP.A……Page 146
A New Features……Page 149
Other New Features……Page 150
B Module Language Syntax……Page 151
Module Language Syntax Diagrams……Page 152
Procedure Definitions……Page 153
WITH INTERFACE CLAUSE……Page 155
C Reserved Words……Page 157
Module Reserved Words……Page 158
D SQLSTATE Codes……Page 163
SQLSTATE Codes……Page 164
E System-Specific References……Page 171
Ada SQL_STANDARD Package……Page 172
Index……Page 173