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 - 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.

WORKFLOW_SAMPLE_ORACLESQLQUERYSTRING.png

 

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

Comments