<< Click to Display Table of Contents >> Navigation:  Connectors > MySQL > Routine Calls

 

The DTS MySQL Connector supports remote calls for any MySQL stored procedures and functions.

 

DTS Naming

 

 

Arguments and Results

 

Functions and procedures with any type of arguments and results are supported, as long as the types themselves are supported. Please see the list of supported types for more information.

 

Metadata

 

The connector is also capable of extracting metadata regarding the arguments and results of a procedure or function:

 

▪DATA_TYPE

▪CHARACTER_MAXIMUM_LENGTH

▪NUMERIC_PRECISION

▪DATETIME_PRECISION

▪NUMERIC_SCALE

▪ORDINAL_POSITION

▪PARAMETER_MODE

 

Standard functionality only makes use of DATA_TYPE, ORDINAL_POSITION and PARAMETER_MODE, but the other items are available for extension in DTS descriptor objects.