Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Oracle8 AQ Message Type Tree Structure
Database Interface Designer Reference Guide
90
The ProcedureCall group is defined in the same way as a Row type for a table
or a query in the type tree. Its group format is determined by the value selected
in the Row group format list in the Generate Type Tree from Tables dialog
box or the Generate Type Tree from Query dialog box, respectively. The
selected group format determines the terminator and release characters.
♦ Similar to the DBTable or DBSelect types in type trees for tables or queries,
the type tree for a stored procedure has a DBProcedure type, which is an
implied group consisting of a series of ProcedureCalls. The stored procedure
is called once for each ProcedureCall in the DBProcedure output.
Note For information about using stored procedures as a data target, refer to Chapter 8
- Using Stored Procedures. For information about generating type trees for a
stored procedure, refer to From a Stored Procedure.
Oracle8 AQ Message Type Tree Structure
The type trees generated by the Database Interface Designer for Oracle8 AQ
messages used as output from a map are different from those generated for
tables, queries, or stored procedures. For information about these type trees, refer
to the Oracle8 AQ Adapter Reference Guide.