bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

Building Queries and Data Views

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.