SQL*Module for Ada Programmer's Guide
Release 8.0

A58231-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Who Should Read This Guide?
Standards Conformance
How the SQL*Module Guide Is Organized
Conventions Used in This Guide
Notation

1 Introduction to SQL*Module

What Is SQL*Module?
Background
Precompilers
The Module Language Concept
SQL*Module as an Interface Builder
What Is Supported by SQL*Module?
What SQL Statements are Not Supported by SQL*Module?

2 Module Language

The Module
An Example Module
A Short Example Program in Ada
Structure of a Module
Preamble
Cursor Declarations
Procedure Definitions
SQL Datatypes
SQL Commands
Text in a Module
Comments
Indicator Parameters
Status Parameters
Error Messages
CONNECT Statement
SET CONNECTION Statement
DISCONNECT Statement
Multi-tasking
ENABLE THREADS
SQL_CONTEXT Datatype
CONTEXT ALLOCATE
CONTEXT FREE
Multi-tasking Restrictions
Multi-tasking Example

3 Accessing Stored Procedures

PL/SQL
Procedures
Stored Procedures
Stored Packages
Accessing Stored Procedures
Case of Package and Procedure Names
Early and Late Binding
Cursor Variables
Cursor Variable Parameters
Allocating a Cursor Variable
Opening a Cursor Variable
Closing a Cursor Variable
Restrictions on Cursor Variables
Dynamic SQL
The WITH INTERFACE Clause
Examples
SQL Datatypes
The Default WITH INTERFACE Clause
Storing Module Language Procedures
Connecting to a Database

4 Developing the Ada Application

Program Structure
Error Handling
SQLCODE
Obtaining Error Message Text
SQLSTATE
Obtaining the Number of Rows Processed
Handling Nulls
Indicator Variables
Cursors
Specification Files
Calling a Procedure
Arrays as Procedure Arguments
National Language Support

5 Running SQL*Module

SQL*Module Input and Output
Input sources
Output Files
Determining the Input Source
Invoking SQL*Module
Running the Compiler
Case Sensitivity in Program Names, Option Names, and Values
Listing Options and Default Values
How to Specify Command-Line Options
Value Lists
Default Values
Configuration Files
Input Files
Output Files
Source Code Output File
Specification File
Listing File
PL/SQL Source Files
Avoid Default Output Filenames
Command-Line Options
AUTO_CONNECT
BINDING
CONFIG
ERRORS
FIPS
INAME
LNAME
LTYPE
MAPPING
MAXLITERAL
ONAME
OUTPUT
PNAME
RPC_GENERATE
SELECT_ERROR
SNAME
STORE_PACKAGE
SQLCHECK
USERID
Compiling and Linking
An Example (Module Language)

6 Demonstration Programs

The SQL_STANDARD Package
SQLCODE
SQLSTATE
Sample Programs
Sample Tables
Module Language Sample Program
Calling a Stored Procedure
Sample Applications
DEMOHOST.A
DEMCALSP.A

A New Features

New Statements
Other New Features

B Module Language Syntax

Module Language Syntax Diagrams
Preamble
Cursors
Procedure Definitions
WITH INTERFACE CLAUSE

C Reserved Words

Module Reserved Words

D SQLSTATE Codes

SQLSTATE Codes

E System-Specific References

System-Specific Aspects of SQL*Module
Supported Compilers
Character Case in Command Lines
Location of Files
Filename Extensions
Ada Output Files
Command Line
Ada SQL_STANDARD Package


Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Index