How to create an Oracle SQLPlus query in a JAMS workflow

Follow

It is possible to make Oracle queries using SQLPlus in a JAMS workflow.

  1. Create a job using the Workflow Execution Method and drag in the "SQL*Plus Script" activity.
  2. Define your Oracle Connection String in the ConnectionString field on the right, be sure to wrap the connection string in quotes.
  3. Define your query in the body of the activity. Ensure that each command is on a separate line and proper Oracle syntax is used.
  4. The result of the query can be stored in a workflow variable using the Int32 variable type.

See the screenshot below for an example.

2017-10-26_1338.png

Have more questions? Submit a request

Comments