Calling bat file from workflow to invoke command line and then run sql

(Doc ID 2344696.1)

Last updated on JANUARY 02, 2018

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.5 and later
Information in this document applies to any platform.

Goal

Can the workflow be used to call executable (.bat files) that can invoke the command line and run a sqlplus

The contents of the .bat file would be something like

cmd /K

sqlplus xxxx/password@server @C:\directory\spool.sql

exit

Even modified the file to do something like this

cmd /K

c:
cd directory

sqlplus xxxx/password@server @spool.sql

exit


When I run such a workflow internally it keeps running and does nothing. Eventually it has to be terminated
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms