I am using the Database action "Run SQL File on Oracle(c) Database Server" which is having many fields in Input and output. Can anybody let me know where can I found the documentation for these actions. I tried searching in docops but after reaching the database group. I found the documentation for only "Test DSN Connection" . Please send me the link which is having the description for the database actions explaining all the input and output fields.
Although you may know, you can see online help as tool tips when mouse over the properties.
If you want to run insert/update/delete statement, you need to write it into *.sql file, and set ; to [Delimiters].
If you want to run PL/SQL statement, please refer to following knowledge article.
How to run PL/SQL script using action? - CA Knowledge
I hope this helps you.
I know you already opened a support case and Piyush is handling it.
I believe Piyush can help you, so I'd like to close this thread.