Automating Oracle script with nolio

Question

I am using nolio in oracle database to automatically execute multiple sql scrips. How should I run it, if I want to execute them on multiple schemas. What's the best practice to follow here?

Answer 1

Depending upon the details of your script you can run them:

• By converting them into CARA actions
• Using plsql command line
• Using build-in oracle script actions

You may face challenges like capturing and parsing the output from the script's execution if soem error occurs. You may like to raise this query in CARA(formerly Nolio) forums.