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

 

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

 

DTS Naming

 

 

Arguments and Results

 

▪Any of the supported data types are also supported as procedure/function argument and result types, including the user-defined types.

▪IN OUT parameters will appear in both the arguments and the results list for a given remote call and will be treated by the connector as two distinct items, one going in, one coming out.

▪Functions returning tables will be have their results wrapped and operated as DTS streams. The same is true for procedures with a single OUT argument which is a table.

 

 

Metadata

 

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

 

▪TYPE_NAME

▪TYPE_OWNER

▪DATA_TYPE

▪DATA_PRECISION

▪DATA_SCALE

▪DATA_LENGTH

▪DATA_LEVEL

▪POSITION

▪DEFAULT_VALUE

▪SEQUENCE

▪IN_OUT

 

Standard functionality only makes use of DATA_TYPE, TYPE_NAME, TYPE_OWNER,  POSITION and IN_OUT, but the other items are available for extension in DTS descriptor objects.