Regarding the documentation for the Database Actions

[aggmo01]

Hello All,

 

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.

 

-Regards

  Mohit

[Yasuyuki Miura]

Hi Mohit,

 

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.

 

Thanks

Yas

[Yasuyuki Miura]

Hi Mohit,

 

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.

 

Thanks

Yas