Using the NQSGetSQLDataTypes Procedure to Access Data Type Information

To access a list of data types supported by Oracle BI EE, use the Oracle BI Server nqcmd utility to run the NQSGetSQLDataTypes procedure.

For example: call NQSGetSQLDataTypes(0);

When you run this procedure, the results contain a list of supported data types and information specific to each data type, such as case sensitivity and searchability.

See Using nqcmd to Test and Refine the Repository for more information about opening and using the Oracle BI Server nqcmd utility.