It is possible to make Oracle queries using SQLPlus in a JAMS workflow.
- Create a job using the Workflow Execution Method and drag in the "SQL*Plus Script" activity.
- Define your Oracle Connection String in the ConnectionString field on the right, be sure to wrap the connection string in quotes - E.g.
- Define your query in the body of the activity. Ensure that each command is on a separate line and proper Oracle syntax is used.
- 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.