I'm using ksc_run_sql command to perform update on some fields in DB. However after execution (does not matter wheter it is execution type command or request type command) I got message Execute commands (Succeeded) in workflow status but the log shows that no command was executed: "All command conditions evaluated to false. No commands were run as a result. Succeeded." I have no conditions set for command (see attached file). Any ideas?
I also had some trouble with this command. It'll only be executed if you set an source environment in workflow. Nevertheless you still must specify an target environment for the special command (ENV="..."). After changing this, you will still get an error. Because as far as I know, you can only run SQL (Select) statements. There is no DML (Update/Delete) allowed. Therefor you need to write an SQL*Plus script and run it with ksc_local_exec.
I had the same experience with DML statements here. If the policies at yours allow you to create additional PL/SQL functionality in the db schema, you create a function with that functionality and call that. You would probably gain a better performance than running a script on the server.