Stored Procedure Support by Database

This section lists stored procedure support by database vendor. Each vendor supports the datatypes supported in their respective databases. The following databases are supported:

• Oracle
• Microsoft SQL Server
• Sybase
• IBM DB2
• Informix

Oracle

Table  8-3 describes the stored procedure support for Oracle databases. Table  8-4 describes Oracle stored procedures return values.

Table 8-3 Oracle Stored Procedure parameter support  

Parameter Mode	Data Types Supported	Notes and Restrictions
input_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.	The PL/SQL %TYPE definitions must be translated to the XML schema types defined in Supported Datatypes.
output_only	A Cursor Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.
input_output	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.

 

Table 8-4 Oracle Stored Procedure returned values support

Return Value	Types Supported
Primitive type	An primitive type such as an integer, a string, etc.
Return cursor	See Table  8-3.

Microsoft SQL Server

Table  8-5 describes the stored procedure support for Microsoft SQL Server databases. Table  8-6 describes Microsoft SQL Server stored procedures return values.

Table 8-5 Microsoft SQL Server Stored Procedure parameter support  

Parameter Mode	Data Types Supported	Notes and Restrictions
input_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.
output_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.	You must map TINYINT values to xs:short in the Stored Procedure Description File.

 

Table 8-6 Microsoft SQL Server Stored Procedure returned values support

Return Value	Types Supported	Notes and Restrictions
Return Status code	An integer value.
Row Set	Single or multiple result sets.	You must map TINYINT values to xs:short in the Stored Procedure Description File.

If you are using procedure groups, see Rules for Procedure Names Containing a Semi-Colon for information on mapping the procedure names to the Stored Procedure Description file and using the names in an XQuery.

Microsoft SQL Server parameter names begin with the @ character, but the name must appear in the Stored Procedure Description file without the @ character. For example, a parameter named @myInputParameter must be mapped as myInputParameter.

Sybase

Table  8-7 describes the stored procedure support for Sybase databases. Table  8-8 describes Sybase stored procedures return values.

Table 8-7 Sybase Stored Procedure parameter support  

Parameter Mode	Data Types Supported	Notes and Restrictions
input_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.
output_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.	You must map TINYINT values to xs:short in the Stored Procedure Description File.

 

Table 8-8 Sybase Stored Procedure returned values support

Return Value	Types Supported	Notes and Restrictions
Return Status code	An integer value.
Row Set	Single or multiple result sets.	You must map TINYINT values to xs:short in the Stored Procedure Description File.

If you are using procedure groups, see Rules for Procedure Names Containing a Semi-Colon for information on mapping the procedure names to the Stored Procedure Description file and using the names in an XQuery.

Sybase parameter names begin with the @ character, but the name must appear in the Stored Procedure Description file without the @ character. For example, a parameter named @myInputParameter must be mapped as myInputParameter.

IBM DB2

Table  8-9 describes the stored procedure support for IBM DB2 databases. Table  8-10 describes IBM DB2 stored procedures return values.

Table 8-9 IBM DB2 Stored Procedure parameter support  

Parameter Mode	Data Types Supported
input_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.
output_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.
input_output	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.

 

Table 8-10 IBM DB2 Stored Procedure returned values support

Return Value	Types Supported
Primitive type	An primitive type such as an integer, a string, etc.
Row Set	Single or multiple result sets.

Informix

Table  8-11 describes the stored procedure support for Informix databases. Table  8-12 describes Informix stored procedures return values.

Table 8-11 Informix Stored Procedure parameter support  

Parameter Mode	Data Types Supported
input_only	Only database data types that you can map to one of the Liquid Data primitive types defined in Supported Datatypes.

 

Table 8-12 Informix Stored Procedure returned values support

Return Value	Types Supported
Row Set	Single or multiple result sets.