UDRs can return only built-in non-opaque types from tables in databases of other database servers. UDRs cannot return the BOOLEAN, BLOB, CLOB, and LVARCHAR built-in opaque data types in cross-server operations.
If an SPL function uses the Return clause to return values from another database of the local database server, the values can built-in types, including built-in opaque types. Also valid are DISTINCT types whose base types are built-in types, and user-defined types, if you explicitly cast the DISTINCT types and UDTs to built-in data types. All of the DISTINCT types, the UDTs, and the casts must be defined in all of the participating databases.
The same data-type restrictions apply to a value that an external function returns from another database.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]