Stored procedures native call syntax

A stored procedure can be accessed from within a map by specifying the native call syntax in:

• A query that is specified in an input card.
• The first argument in a DBQUERY or DBLOOKUP function.

  This argument does not need to be a literal. The arguments to the stored procedure might be determined at map execution time.

• The SQL Statement adapter command (-STMT) in DBQUERY, DBLOOKUP, or GET functions.

For information about using DBLOOKUP or DBQUERY, or for information about using the syntax for device-independent calls to access return values and output adapter commands, see the Database Interface Designer documentation. In addition, you will find information about calling stored procedures with object type parameters.

For example, a call to a stored procedure using Oracle in a DBLOOKUP might be:

DBLOOKUP ("begin MyAddNameProc(' "+ Name:Column + " ',-1);end;"
 "mydb.mdq", 
 "MyDB")