Invoke SQL Statement Page

Enter the SQL statement values. The Run a SQL Statement page appears when Run a SQL Statement is selected as the operation to perform 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) 
```
When configuring the adapter as an invoke connection, define all bind parameters in the same order and define the parameters that takes absolute values at the end.
```
INSERT INTO table_name (EMPNO, EMPNAME, EMPUUID, EMPPHONE, EMPHIREDATE) VALUES (#EMPNO, #EMPNAME, Sys_guid(), NULL, SYSDATE)
```

Element	Description
SQL Query	Identifies the SQL query.
Validate SQL Query	Validates the SQL query syntax.
Status	Displays the SQL query syntax validation status. When syntax validation is successful, the message `Success!` appears.