Release Automation

 View Only
  • 1.  Regarding the documentation for the Database Actions

    Posted Apr 05, 2018 08:48 AM

    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



  • 2.  Re: Regarding the documentation for the Database Actions
    Best Answer

    Broadcom Employee
    Posted Apr 05, 2018 09:43 PM

    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



  • 3.  Re: Regarding the documentation for the Database Actions

    Broadcom Employee
    Posted Apr 11, 2018 03:04 AM

    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