Invoke Run a SQL Statement Page

Enter the SQL statement parameters. The Run a SQL Statement page is the wizard page that is displayed if you selected Run a SQL Statement as the operation type on the Basic Info page.

Note:

Do not use schema/database names in SQL queries. Configure the details in the connection. For example:
```
Update HR.employee set HR.employee.first_name = 'Name' where HR.employee.employee_id='1' 
```
can be changed to a simple query, such as:
```
Update employee set first_name = 'Name' where employee_id='1'
```
where HR is used in the connection details. This restricts a user with specific privileges to a particular schema/database.
When configuring the adapter as an invoke connection, ensure that proper spaces are provided between key words for a pure SQL statement. For example, the following statement fails during integration activation because there is no blank space between VALUES and (#.
```
INSERT INTO table_name VALUES(#EMPNO, #EMPNAME)
```
Add a blank space between VALUES and (#, and the statement is successfully processed.
```
INSERT INTO table_name VALUES (#EMPNO, #EMPNAME)
```

Element	Description
SQL Query	Enter a SQL query.
Status	Display the results of the SQL query validation. The Status field displays `Success!` when a query is successfully validated.