Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
121
Chapter 8 - Using Stored Procedures
This chapter describes the various mechanisms for using stored procedures to
access all types of parameters and return values from stored functions. You can
call stored procedures when using
DBQUERY and DBLOOKUP functions and when
defining a query in the Database Interface Designer for a map data source. When
defining a database as the target for an output card, you can also output to a
stored procedure.
Note For information about the availability and usage of calling stored procedures,
including the correct native syntax for these calls, refer to each database-specific
adapter reference guide.
Calling Stored Procedures
When used as a source of data in one of the database functions (DBQUERY or
DBLOOKUP), in a GET function, or in a query defined in the Database Interface
Designer, there are two ways to call stored procedures:
♦ Use the database-independent syntax for calls.
This provides a means of accessing the output parameters and return values
from stored functions.
♦ Use the native syntax for the database.
Using this method, you cannot access output parameters or return values from
stored functions.
In addition to the above methods, when using Oracle object types as parameters in
stored procedures, there is a special syntax that must be used. For more
information about this, refer to Stored Procedures with Object Type Parameters.