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

Master Index

Feedback

Go to next page

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

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

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback