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 - E.g.
    User Id=myUsername;Password=myPassword"
  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.



Looking for instructions on how to run an Oracle Package? Check out our Article, Calling a SQL Package in JAMS.

Have more questions? Submit a request