How to create an Oracle SQLPlus query in a JAMS workflow


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.


Have more questions? Submit a request