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

Valid User-Defined SQL Statements for Oracle Database Targets

Article #: Product: Version:

Summary

When defining Oracle database targets, SQL statements that insert/update/delete data, or a stored procedure that returns no data, can be invoked from the User defined SQL statement tab of the Target 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 Target Database Table dialog:

Resolution

You can enter the following as SQL text in the User defined SQL Statement tab of the Target Database Table dialog when defining Oracle targets:

Additional Information

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

Last updated: