My Oracle Support Banner

Calling bat file from workflow to invoke command line and then run sql (Doc ID 2344696.1)

Last updated on JUNE 27, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.