In a stored procedure, you can define the output fields based on the DBMS that you use, such as MySQL, SQL Server, Oracle, PostgreSQL, or DB2. You can use the output fields to return the data back to the calling application. A stored procedure reduces the network traffic by returning multiple output fields in a single call instead of performing multiple queries to the database.

You can use the following data types in the output fields for stored procedures in a data access service connector:

Binary
Byte
Clob
Date
Double
Float
Integer
Long
Short
String