SQL*Module for Ada Programmer's Guide
Release 8.0
A58231-01
Library
Product
Index
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
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Library
Product
Index
