Currently the Action Palette only accepts running script files that are saved locally. How to add a new action set to run a procedure from database or run "EXEC <procedure name>" and be able to schedule this action?
WORKAROUND:
1. Create a script file of an anonymous block that runs the desired procedure or any other database object as such:
BEGIN
<schema name>.<procedure name>;
END;
2. Save the file as a SQL file and run it through Action Palette.
STATUS:
Enhancement request ER 34367 has been submitted to Development for consideration in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center