qua_execute_provider_sql_on_connection

Executes provider specific sql query on given connection. The code will be executed directly on provider database, therefore it must be written in SQL dialect specific to given connection. For example, if @connection_name is a name of Oracle connection, then @sql should use Oracle dialect of SQL instead of T-SQL.

Arguments

connection_name

Connection name that will be used to execute given SQL code.

sql

Provider specific SQL code.

Example

Drops a table on Oracle using Querona connection.

EXEC qua_execute_provider_sql_on_connection @connection_name = 'OracleConnection', @sql='DROP TABLE list_customers PURGE;';

Notice the PURGE clause, that is specific to Oracle and not present in T-SQL.