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 and later
Information in this document applies to any platform.


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


Even modified the file to do something like this

cmd /K

cd directory

sqlplus xxxx/password@server @spool.sql


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


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