I have to do a report automation and as a part of that i have to execute some stored procedures with input parameters. Is it possible to add the execute SP scripts to a sql file and do execute sql in the TOAD Automation?
Try using the Execute Script activity with anonymous block of code calling SP. If the input vars are coming from a prior execution you might need to do a find and replace for these values. Give it a go and if you run into issues send me a sample of your sql and automation file.