Configuring Oracle Database Adapter Invoke SQL Statement Operation Properties

Enter the Oracle Database Adapter SQL statement operation parameters.

Topics

What You Can Do from the SQL Statement Operations Page

You can specify the following values on the SQL Statement Operations page. The SQL Statement Operations page is the wizard page that is displayed if you selected SQL Statements as the operation type on the Basic Info page.

Type an SQL query.
Click Validate SQL Query to ensure that your query has correct syntax and specifies tables, fields, and values that exist.
Make sure that after you click Validate SQL Query, the Status field displays Success!
Some syntax errors are subtle. For example, this statement results in an error:
```
insert into AddressTable values(#NAME) 
```
This statement, with a space added after values, is correct:
```
insert into AddressTable values (#NAME) 
```

What You See on the SQL Statement Operations Page

The following table describes the key information on the SQL Statement Operations page.

Element	Description
SQL Query	Type an SQL query.
Status	After you click Validate SQL Query, make sure the Status field displays Success!