New Features

This appendix describes the new features offered in the Pro*Ada Precompiler, Release 1.8. Each new feature is described briefly, and a reference to the more complete description in the guide is provided. The following new features are discussed:

UNSAFE_NULL option

tasking

UNSAFE_NULL option

When working with Pro*Ada source files that FETCH data into a host variable without an accompanying indicator variable, an ORA-01405 message is generated if a NULL is returned to the host variable. Beginning with Pro*Ada release 1.8, you can disable the ORA-01405 message by using the command-line option UNSAFE_NULL=YES.

The addition of the UNSAFE_NULL option eases migration from Oracle Version 6 to Oracle7. If you are upgrading to Oracle7 and use DBMS=V6 when precompiling, you will be unaffected by the addition of this option. Precompiler applications using DBMS=V6 maintain full compatibility with Oracle v6.

The UNSAFE_NULL option has no effect on host variables in an embedded PL/SQL block. In that case, you must use indicator variables to avoid ORA-01405 errors.

For more information, see the section "Fetching Nulls Without Indicator Variables" .

Tasking

Ada provides tasking, allowing separate threads to execute concurrently within a larger process. Ada tasking is supported by the release 1.8 Pro*Ada precompiler.

To enable tasking in your program, you must enable multi-threading. Do this by coding the statement

EXEC SQL ENABLE THREADS

in your main Pro*Ada program, before any calls are made to subprograms that use tasking. When you precompile your Pro*Ada sources, you also must use the command-line option THREADS, specifying the value YES. For example

proada my_file ... THREADS=YES

See the section "Tasking" for more information.

Prev Next

Library

Product

Contents

Index