Invoke Run a SQL Statement Page

Enter the SQL statement values. The Run a SQL Statement page appears when you select the Run a SQL Statement operation on the Basic Info page. You can specify the following values on the Run a SQL Statement 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 the SQL query.
Status	The Status field displays `Success!` when a query is successfully validated.