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.
   

   "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
   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.