Skip Headers
Oracle® SQL*Module for Ada Programmer's Guide
Release 8.0
Part Number A58231-03
Home
Book List
Index
Master Index
Feedback
Next
View PDF
Contents
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Intended Audience
Documentation Accessibility
Standards Conformance
Structure
Related Documents
Conventions
1
Introduction to SQL*Module
1.1
What Is SQL*Module?
1.1.1
Background
1.1.2
Precompilers
1.1.3
The Module Language Concept
1.2
SQL*Module as an Interface Builder
1.3
What Is Supported by SQL*Module?
1.4
What SQL Statements are Not Supported by SQL*Module?
2
Module Language
2.1
The Module
2.1.1
An Example Module
2.1.2
A Short Example Program in Ada
2.2
Structure of a Module
2.2.1
Preamble
2.2.1.1
MODULE Clause
2.2.1.2
LANGUAGE Clause
2.2.1.3
AUTHORIZATION Clause
2.2.2
Cursor Declarations
2.2.3
Procedure Definitions
2.2.3.1
Procedure Name
2.2.3.2
Parameter List
2.2.3.3
SQL92 Syntax
2.3
SQL Datatypes
2.4
SQL Commands
2.5
Text in a Module
2.5.1
Comments
2.6
Indicator Parameters
2.7
Status Parameters
2.7.1
Error Messages
2.8
CONNECT Statement
2.8.1
SET CONNECTION Statement
2.9
DISCONNECT Statement
2.10
Multi-tasking
2.10.1
ENABLE THREADS
2.10.2
SQL_CONTEXT Datatype
2.10.3
CONTEXT ALLOCATE
2.10.4
CONTEXT FREE
2.10.5
Multi-tasking Restrictions
2.11
Multi-tasking Example
3
Accessing Stored Procedures
3.1
PL/SQL
3.1.1
Procedures
3.2
Stored Procedures
3.3
Stored Packages
3.4
Accessing Stored Procedures
3.5
Case of Package and Procedure Names
3.6
Early and Late Binding
3.7
Cursor Variables
3.7.1
Cursor Variable Parameters
3.7.2
Allocating a Cursor Variable
3.7.3
Opening a Cursor Variable
3.7.3.1
Opening in a Stand-alone Stored Procedure
3.7.3.2
Return Types
3.7.4
Closing a Cursor Variable
3.7.5
Restrictions on Cursor Variables
3.8
Dynamic SQL
3.9
The WITH INTERFACE Clause
3.9.1
Examples
3.9.2
SQL Datatypes
3.9.2.1
DATE Datatype
3.9.3
The Default WITH INTERFACE Clause
3.9.3.1
Procedures
3.9.3.2
Functions
3.10
Storing Module Language Procedures
3.11
Connecting to a Database
4
Developing the Ada Application
4.1
Program Structure
4.2
Error Handling
4.2.1
SQLCODE
4.2.2
Obtaining Error Message Text
4.2.3
SQLSTATE
4.3
Obtaining the Number of Rows Processed
4.4
Handling Nulls
4.4.1
Indicator Variables
4.5
Cursors
4.6
Specification Files
4.7
Calling a Procedure
4.8
Arrays as Procedure Arguments
4.9
National Language Support
5
Running SQL*Module
5.1
SQL*Module Input and Output
5.1.1
Input sources
5.1.2
Output Files
5.1.3
Determining the Input Source
5.2
Invoking SQL*Module
5.2.1
Running the Compiler
5.3
Case Sensitivity in Program Names, Option Names, and Values
5.3.1
Listing Options and Default Values
5.4
How to Specify Command-Line Options
5.4.1
Value Lists
5.4.2
Default Values
5.5
Configuration Files
5.6
Input Files
5.7
Output Files
5.7.1
Source Code Output File
5.7.1.1
Default File Names for Ada
5.7.2
Specification File
5.7.2.1
Default Specification Filenames for Ada
5.7.3
Listing File
5.7.4
PL/SQL Source Files
5.7.5
Avoid Default Output Filenames
5.8
Command-Line Options
5.8.1
AUTO_CONNECT
5.8.2
BINDING
5.8.3
CONFIG
5.8.4
ERRORS
5.8.5
FIPS
5.8.6
INAME
5.8.7
LNAME
5.8.8
LTYPE
5.8.9
MAPPING
5.8.10
MAXLITERAL
5.8.11
ONAME
5.8.12
OUTPUT
5.8.13
PNAME
5.8.14
RPC_GENERATE
5.8.15
SELECT_ERROR
5.8.16
SNAME
5.8.17
STORE_PACKAGE
5.8.18
SQLCHECK
5.8.19
USERID
5.9
Compiling and Linking
5.9.1
An Example (Module Language)
6
Demonstration Programs
6.1
The SQL_STANDARD Package
6.1.1
SQLCODE
6.1.2
SQLSTATE
6.2
Sample Programs
6.2.1
Sample Tables
6.2.1.1
MKTABLES.SQL
6.2.1.2
DEPARTMT.SQL
6.2.1.3
INSTRUCS.SQL
6.2.1.4
STUDENTS.SQL
6.2.1.5
COURSES.SQL
6.2.1.6
EMROLMNT.SQL
6.2.2
Module Language Sample Program
6.2.3
Calling a Stored Procedure
6.3
Sample Applications
6.3.1
DEMOHOST.A
6.3.2
DEMCALSP.A
A
New Features
A.1
New Statements
A.2
Other New Features
B
Module Language Syntax
B.1
Module Language Syntax Diagrams
B.1.1
Preamble
B.1.1.1
LANGUAGE Clause
B.1.1.2
AUTHORIZATION Clause
B.1.2
Cursors
B.1.3
Procedure Definitions
B.2
WITH INTERFACE CLAUSE
C
Reserved Words
C.1
Module Reserved Words
D
SQLSTATE Codes
D.1
SQLSTATE Codes
E
System-Specific References
E.1
System-Specific Aspects of SQL*Module
E.1.1
Supported Compilers
E.1.2
Character Case in Command Lines
E.1.3
Location of Files
E.1.4
Filename Extensions
E.1.5
Ada Output Files
E.1.6
Command Line
E.1.7
Ada SQL_STANDARD Package
Index