FAQ > Valid User-Defined SQL Statements for Oracle Database Sources

Valid User-Defined SQL Statements for Oracle Database Sources

Article #: Product: Version:

Summary

When defining Oracle database sources, SQL SELECT statements that select data, or call a function that returns a value, can be invoked from the User defined SQL statement tab of the Source Database Table dialog. Errors are issued by DMExpress when using inappropriate syntax or calling an unsupported statement.

Symptom

The following error messages may be issued by DMExpress when using unsupported expressions or invalid syntax in the User defined SQL statement tab of the Source Database Table dialog:

Resolution

You can enter the following as SQL Text in the User defined SQL statement tab of the Source Database Table dialog when defining Oracle sources:

When using user-defined SQL to define an Oracle source, adhere to the following guidelines:

Attachments

See the attached file, 131_Examples.pdf , for complete definitions of objects used in the above examples.

Additional Information

A TABLE collection expression tells Oracle that the value returned by a collection expression should be treated as a table. The collection expression can be a sub-query, a nested table column, a function, or a collection constructor which returns a collection.

For more information on Oracle collection data types, refer to the Oracle documentation.

For details on user-defined SQL statements for Oracle sources, see Source Database Table dialog in the DMExpress Help.

Last updated: